Posted by Garry on September 17, 2000 5:27 AM
I have a workbook with numerous sheets both displayed and hidden.
About 20 of use this workbook to record our results.
The workbook and all sheets are all password protected.
From time to time I have to make minor changes to all copies
which the guys Email to me
I'm having difficulty with a macro that will;
Open the workbook, remove my password on several of the worksheets,
Unhide the hidden worksheets that are protected with my password,
and then after hiding it protecting the individual sheets and workbook
with my password again.
With some 20 workbooks to modify its becoming time consuming.
I'm using Excel95.