Password Protect Macro - Compile Error

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top