#1   Report Post  
Karen
 
Posts: n/a
Default Unprotect Sheets

Is there a way to unprotect a series of worksheets?
All of the worksheets have the same password.
When I group the worksheets and go to Tools Protection,
the "Unprotect Sheet" opeion is grayed out.

Thank you
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
not possible without VBA

--
Regards
Frank Kabel
Frankfurt, Germany

"Karen" schrieb im Newsbeitrag
...
Is there a way to unprotect a series of worksheets?
All of the worksheets have the same password.
When I group the worksheets and go to Tools Protection,
the "Unprotect Sheet" opeion is grayed out.

Thank you


  #3   Report Post  
Karen
 
Posts: n/a
Default

Does anyone have any VBA code to unprotect a series of
worksheets?
Thank you

-----Original Message-----
Hi
not possible without VBA

--
Regards
Frank Kabel
Frankfurt, Germany

"Karen" schrieb im

Newsbeitrag
...
Is there a way to unprotect a series of worksheets?
All of the worksheets have the same password.
When I group the worksheets and go to Tools

Protection,
the "Unprotect Sheet" opeion is grayed out.

Thank you


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PROTECTING/UNPROTECTING SHEETS Maureen Excel Discussion (Misc queries) 1 January 6th 05 06:46 PM
Multiple sheets selected twa14 Excel Discussion (Misc queries) 2 December 21st 04 11:15 AM
Printing separate sheets on one paper sheet Attyla Excel Discussion (Misc queries) 2 December 19th 04 05:58 PM
Linking sheets to a summary sheet in workbook gambinijr Excel Discussion (Misc queries) 4 December 16th 04 08:13 PM
CountIF across multiple sheets in a workbook Al Excel Worksheet Functions 1 October 29th 04 01:15 PM


All times are GMT +1. The time now is 01:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"