Password protecting a workbook

[Ekoor]

Please help with syntax error for code below:

ActiveWorkbook.SaveAs Filename:= ("C:\Users\abek276\Desktop\REPORTS1\, FileFormat:=xlExcel8,Password: ="hell001", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False)& MyName

[aarona]

try

Please Login or Register  to view this content.

[Ekoor]

thanks but his isn't working.

how do you add in the password to the Save as bit of code?

[Ekoor]

thanks but his isn't working.

how do you add in the password to the Save as bit of code?

[Ekoor]

this is my current code:

ActiveWorkbook.SaveAs ("C:\Users\abek276\Desktop\REPORTS1\") & MyName

how do you add in the password to the Save as bit of code?

[Ekoor]

need Urgent assistance anyone?

[Aardigspook]

You had a bracket and the & MyName in the wrong place.

Try this:

Please Login or Register  to view this content.

[Ekoor]

This is perfect.... thanks

[AliGW]

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

need Urgent assistance anyone?

This is a forum manned by volunteers in their spare time, not a paid 'service' - please don't expect urgent attention. Thanks.

[Ekoor]

Noted

Thanks

[Aardigspook]

You're welcome.
If that takes care of your original question, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Thanks.