View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stilla Stilla is offline
external usenet poster
 
Posts: 25
Default Macro to protect multiple sheets?

Hello! Thanks in advance for your help.

How can I modify the macro (below line) I recorded to protect a sheet so
that I can use it multiple sheets at once. I have a workbook with 20 tabs.
I'd like to be able to protect and unprotect all sheets at once.
_________________________
PROTECTSHEET Macro
Keyboard Shortcut: Ctrl+p

ActiveSheet.Protect Password:="mypassword", DrawingObjects:=True,
Contents:=True, Scenarios:=True
__________________________