microsoft+excel+training - How do you automatically prtotect multiple worksheets

Hi Ryan. The simplest way to generate the code for this is to record a macro and then carry out the tasks. You can protect the current worksheet by accessing the ActiveSheet.Protect object and sheets can be similarly hidden simply by specifying which ones you want. Create macros to protect/unprotect, hide/unhide, assign them to icons on your toolbar and you're away!

Hope this helps,

Anthony