Thread
:
Passowrd Protecting
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
Passowrd Protecting
try a loop something like
for each ws in worksheets
If ws.Name < "Sheet1" Then do your thing
Next ws
--
Don Guillett
SalesAid Software
"TheRook" wrote in message
...
I currently have 8 sheets within a workbook which are protected, on each
sheet I have some locked and unlocked cells. Each worksheet is for each
day
of the week plus a totals sheet, therefore the layout for each sheet is
identical. At present If I need to make an amendment to any of the locked
cells I have to unprotect every sheet make the change and then proect
every
sheet.
Is there anyway of proecting ALL the sheets at once and unprotecting them
all at once as this would reduce the time it takes.
Regards
The Rook
Reply With Quote