LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Protect & Unprotect Several Worksheets
 
Posts: n/a
Default How to protect and unprotect 30 worksheets in a file every month .

Situation: I have a workbook with over 30 worksheets, the worksheets have
data entry areas which are unblocked (our data entry person puts the data in
those areas) and also formula areas which are blocked, I protect each
worksheet individualy to save the formulas from being altered accidently by
data entry person.
Every month I need to unprotect all 30 worksheets and adjust the formulas
for the new month and then protect all 30 worksheets again to make them ready
for data entry person again.

Question:Is there any way to protect all 30 worksheets in one step instead
of 30
times, and unprotect them all 30 in one step instead of 30 times?

IREAD ONLY does not solve the problem, because it does not allow the data
entry person to work on the same file.
 
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
Is there any way that you can protect or unprotect a group of wor. CheriT63 Excel Discussion (Misc queries) 9 January 8th 05 08:40 PM


All times are GMT +1. The time now is 08:41 AM.

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"