View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Password Protect Macro - Compile Error

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.

Teddy-B wrote:

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


--

Dave Peterson