Protect Workbook with Password

[Mouctar]

Hi Everyone,

I am trying to save as new workbook with password. i have used below code to make it work but it's not working, as after running macro, the saved workbook can be opened with no password require.In another words how do i save the workbook with password protection when someone else try to open ? Any help will do

i hope this makes sense

Thank you

Please Login or Register  to view this content.

[Logit]

.
.
Using this code in a UserForm:

Please Login or Register  to view this content.

[Arkadi]

Mouctar,

when posting code, please use code tags, as per rule #3 on the forum rules.

The protection you are using does not stop others from opening the workbook, it just prevents them from adding or removing sheets, or hiding/unhiding them.

To password protect to open it, try:

Please Login or Register  to view this content.

Also some general advice: the whole point of using With... is to avoid having to type it again, so this:

Please Login or Register  to view this content.

would actually look like this:

Please Login or Register  to view this content.

[6StringJazzer]

Your code protects against changes to the file once it's opened but it does not prevent it from being opened. You want this:

Please Login or Register  to view this content.

Also, as noted, code tags are required. I added them for you since you are a new user but please read our rules.

[6StringJazzer]

.
.
Using this code in a UserForm:

Unfortunately this method requires macros to be enabled. This can be defeated by simply turning off macros when opening the file.

[Mouctar]

Hi , Thank you for your help and i have tried this method and i am getting error. is there any other way to protect the workbook for not open without password please ?

[Logit]

Unfortunately this method requires macros to be enabled. This can be defeated by simply turning off macros when opening the file.

For most situations, it would work. Unfortunately there is no fool proof way of keeping anyone out of an Excel file.

[Arkadi]

Did you try this version:

Please Login or Register  to view this content.

[Mouctar]

Hi, Thank you for your help and i have tried your method but still not working as i can open the save workbook with no password required. Please see below full code and may be i have messed up the whole coding and if you don't mind tidy up please.

Please Login or Register  to view this content.

[nigelog]

Mouctar - you will be asked to use code tags - look them up

[6StringJazzer]

We provided two notices about this, so now I'm going to have to insist.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Mouctar]

Sorry, i have now amended and thank you for your help

[Arkadi]

Try changing this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

note that thiswb.path will not work because that only returns the directory the file is in, but not the actual file name, so it would give an error or just save it as the wrong name (adds .xlsm to the last part of the folder structure)

[Mouctar]

Hello! thank you so much and its now working. Much appreciated
Another question!

What is the correct code to send these workbooks as attachment to different recipients ?

Thank you

[bakerman2]

Another question!

In that case please start another thread since your new question isn't in anyway related to this one.