VBA: saving workbook with password error

[Broobi]

Hi All

Hoping someone can help me out with an error i'm getting with this bit of code please

When i try to run this code i get a "Named Arugument Not Found"

Please Login or Register  to view this content.

Any help is greatly appreitated

My thanks in advance!

[Kenneth Hobson]

Where did you set the value of CBFile? It is not even dimmed.

[Broobi]

Sorry!! forgot that bit... see below (my knowledge of VBA isn't great I'm afraid!)

Please Login or Register  to view this content.

[Kenneth Hobson]

If you want to change the password, then save your master file with the password, do your thing, and then change the master file's password to something else. As Compile will show you, SaveCopyAs only has one input parameter.

Tip: Debug.Print can be a good debugging tool to show results in the Immediate window after a run. e.g.

Please Login or Register  to view this content.

[Broobi]

Hi Ken

Thanks for the reply

Looking at your suggestion, I can't see where the value of cbpass is applied to the workbook as the password when saving it? am I missing something?

would something like...

Please Login or Register  to view this content.

work better?

Many thanks

[Kenneth Hobson]

That will add the password which can be different than the master file's password. Saving a Copy As is fast and leaves your master file still open. The solution depends on what your goals are.

[Broobi]

Hi Ken

got it!

SO like you said, i changed it to SaveAs added in and it worked great! :D

Thank your for your help on this, was really appretiated!

for other peoples ref my final code was:

Please Login or Register  to view this content.