Thread: Password Protect Macro - Compile Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teddy-B Teddy-B is offline
external usenet poster
  
Posts: 76
Default Password Protect Macro - Compile Error
Please help me to discover what is wrong with this excerpt from a macro that
I am writing to protect a sheet in my workbook with a password. I keep
getting the compile error message.
__________________________________________________
ActiveSheet.Protect Password:="PASS" DrawingObjects:=True,
Contents:=True, Scenarios:=True
ActiveWindow.SelectedSheets.Visible = False

Reply With QuoteReply With Quote