Password Protect Macro - Compile Error

  • Thread starter Thread starter Teddy-B
  • Start date Start date
T

Teddy-B

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
 
What line causes the error?

Those first two lines are really one logical line:

ActiveSheet.Protect Password:="PASS", DrawingObjects:=True, _
Contents:=True, Scenarios:=True

And you need a comma between each parameter (before drawingObjects)

The spacecharacter followed by an underscore is the continuation character in
VBA.
 
Back
Top