Skip to main content

Conas ilbhileoga oibre a chosaint gan chosaint in Excel ag an am céanna?

Má tá leabhar oibre agat tá iliomad bileoga oibre cosanta leis an bhfocal faire céanna, agus anois ní mór duit iad a chosaint chun roinnt faisnéise a mhodhnú. B’fhéidir, is féidir leat na bileoga a chosaint ceann ar cheann le Bileog Gan Chosaint in Excel, ach cuirfidh sé sin amú go leor ama nuair a bhíonn iliomad bileoga ann gan chosaint. Anseo, tabharfaidh mé roinnt bealaí gasta duit chun ilbhileoga cosanta a chosaint.

Gan mórán bileoga a chosaint ag an am céanna le cód VBA

Gan mórán bileoga a chosaint ag an am céanna le Kutools le haghaidh Excel


mboilgeog cheart gorm saighead Gan mórán bileoga a chosaint ag an am céanna le cód VBA

Má tá tú go maith ar chód VBA, d’fhéadfadh go gcuideodh an cód seo a leanas leat go tapa chun ilbhileoga a chosaint ag an am céanna.

1. Coinnigh síos an ALT + F11 eochracha, agus osclaíonn sé an Microsoft Visual Basic d’Fheidhmchláir fhuinneog.

2. Cliceáil Ionsáigh > Modúil, agus greamaigh an cód seo a leanas i bhFuinneog an Mhodúil.

Sub unprotect_all_sheets() 
On Error Goto booboo 
unpass = InputBox("Please enter the password:") 
For Each Worksheet In ActiveWorkbook.Worksheets 
Worksheet.Unprotect Password:=unpass
Next
Exit Sub 
booboo: MsgBox "There is s problem - check your password, capslock, etc." 
End Sub 

3. Ansin brúigh F5 eochair chun an cód a rith, agus an focal faire a chuir tú isteach ar na bileoga cosanta a iontráil. (caithfidh an focal faire céanna a bheith ag na bileoga cosanta) Féach an pictiúr:

4. Cliceáil OK, agus tá na bileoga cosanta gan chosaint ag an am céanna.


mboilgeog cheart gorm saighead Gan mórán bileoga a chosaint ag an am céanna le Kutools le haghaidh Excel

Kutools le haghaidh Excel'S Bileog Oibre Gan Chosaint Is uirlis áisiúil í a chabhróidh leat go tapa gan leatháin a chosaint leis an bhfocal faire céanna ag an am céanna.

Kutools le haghaidh Excel : le níos mó ná 300 breiseán áisiúil Excel, saor in aisce le triail gan aon teorannú i 30 lá

Tar éis a shuiteáil Kutools le haghaidh Excel, déan mar a leanas le do thoil:

1. Cliceáil Kutools Plus > Bileog Oibre Gan Chosaint, féach ar an scáileán:

2. Sa an Bileog Oibre Gan Chosaint bosca dialóige, liostálfar na bileoga cosanta sa Bileog Oibre bosca liosta, ansin seiceáil ainmneacha na mbileog ar mhaith leat gan chosaint, agus cliceáil OK, ansin cuir isteach an focal faire a chuir tú isteach ar na bileoga cosanta (caithfidh an focal faire céanna a bheith ag na bileoga cosanta) sa bhosca dialóige popped out, féach an scáileán:

3. Agus ansin cliceáil OK, meabhróidh bosca pras duit cé mhéad bileog a bhí gan chosaint. Ansin cliceáil OK, tá na bileoga roghnaithe go léir gan chosaint i do leabhar oibre. Féach an pictiúr:

Leid: Chun na bileoga oibre go léir laistigh de do leabhar oibre a chosaint ag an am céanna, níl le déanamh agat ach iarratas a dhéanamh Bileog Oibre a Chosaint of Kutools le haghaidh Excel mar a thaispeántar an pictiúr seo a leanas:

Íoslódáil agus triail saor in aisce Kutools le haghaidh Excel Now!


mboilgeog cheart gorm saighead Taispeántas: Cosain agus Déan cosaint ar ilbhileoga ag an am céanna le Kutools le haghaidh Excel

Kutools le haghaidh Excel: le níos mó ná 300 breiseán áisiúil Excel, saor in aisce le triail gan aon teorannú i 30 lá. Íoslódáil agus triail saor in aisce Anois!

Airteagal gaolmhar:

Conas iliomad bileoga oibre a chosaint ag an am céanna in Excel?

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup    VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle    Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla    Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc


Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
Comments (12)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Nice - thank you so much! Worked like as charm.

I assume there is also a "Lock Everything back Up" Option??
This comment was minimized by the moderator on the site
This code worked for years, but now it doesn't :( It always says password error, but if I individually unlock each tab it is fine. Did something change with excel to wreck the code?
This comment was minimized by the moderator on the site
Hello, LL,
I have tested the code, it works well in my workbook, could you upload your file here if you don't mind? we can help to check the problem.
Or you can try our KTE feature this article introduces, it supports a 30-day free trial with full features, you can download it here: https://www.extendoffice.com/download/kutools-for-excel.html.

Thank you!
This comment was minimized by the moderator on the site
Hi,

in my work i have to deal every day with multiple excel files , and inside each one protect sheets, all has same password , 7b7b3b1b5b5b5 is there any way to unprotect all the sheets inside for example ( 100 excel files and more ).

best regards,
This comment was minimized by the moderator on the site
Hello Ali,

Glad to help. You can use our Decrypt workbooks feature of Kutools Plus of Kutools for Excel. You can choose no matter how many files, then input the passward. Just a few clicks and all is done. Please see the screenshots.

Our Kutools for Excel supports a 30-day free trial with full features. Here is the download link: https://www.extendoffice.com/download/kutools-for-excel.html. Plesae have a try.

Sincerely,
Mandy
This comment was minimized by the moderator on the site
I just installed it, but I don't see the "Enterprise" tab on the menu. I wanted to test the feature to unprotect multiple sheets at once, but can't find that feature anywhere. The options I have on my menu are Kutools and Kutools Plus, but not Enterprise. What am I missing?
This comment was minimized by the moderator on the site
Hello, Paulo,
Sorry for this, the Enterprise tab has been renamed as Kutools Plus, you can find the Unprotect Worksheet from the Kutools Plus tab, please check the below screenshot:
This comment was minimized by the moderator on the site
When you say "Unprotect multiple sheets at once with Kutools", does it actually do it at once, in parallel, or does it still do it sequentially? (Does this provide a speed improvement over doing it sequentially?) thank you
This comment was minimized by the moderator on the site
Is it possible to lock sheets, but retain the ability to add rows and use filters.
This comment was minimized by the moderator on the site
worked !! thanks handy command
This comment was minimized by the moderator on the site
Hello Sir, unprotect multiple sheets at once is very useful for me. thanks!
This comment was minimized by the moderator on the site
I downloaded the kutools (trial version) and installed it as an administrator. I opened a workbook that had 12 worksheets that were protected with same password. Ran the unprotect utility and followed instructions. it said that all Sucessfully unprotected 12 sheets. when I tried to edit them it said the worksheet is password proctected. It did not work. I am not doing something correctly.
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations