Hi again Jill,
Thanks for your Private Message re using a single button to perform the above actions on each worksheet within the workbook.
This can certainly be done, but how you assign worksheet passwords will determine how complicated the code will be. Your PM suggests that you allow Users to select their own passwords for the worksheets. If this is the case, then either the Users will need to enter their password each time the CommandButton is pressed (probably not what you have in mind), or else the password initially entered by the User will need to be stored (and hidden!) somewhere within the workbook.
If you intend to have an overall "Master Password" (assigned by an Administrator) for the worksheets, the process becomes simpler.
Please let me know which of the above alternatives you would prefer, or suggest a different approach if appropriate.
To allow selection of Locked as well as Unlocked cells, and to allow formatting of Rows, Columns and individual Cells you should modify your code as follows:
Regards,
Greg M
Bookmarks