Help neded! Password restricting/protecting copy file!

[dgavranovic]

I would like to password protect the excel workbook. You need a password to view the contents of the workbook!
I figure how to do that with the original file!
The problem is i have a macro that creates a copy of itself and clears the contents for the next use (ie. like Invoice), and i would like to protect the copy file!
Please Help!

[tony h]

I don't understand your question.

[timmatthews]

i think your looking for ActiveWorkbook.Protect after you save it.

[dgavranovic]

I have protected workbook, (I know how to do that) what i mean is that you can only put info in the selected cells!
When you click save button (macro assign to it) it will save all the content (make a copy of it self in different folder), make a new reference number and clear the cells that need to be cleared!
What i need now is the copy file, I want to restrict who is able to read a file and adjust the contents!

Please Login or Register  to view this content.

This code only works for original file, not the copy!

[timmatthews]

I'm sorry then, like tony I don't think I understand your question.

[timmatthews]

let me take one more swing at this. would it work to fix this in windows instead of vba? can you just set acl's to limit file access to the folder you save it into?

[dgavranovic]

Possibly, but i do not know how!

[tony h]

You can find all the locked cells using the below. You will just need to loop through them clearing each cell

Please Login or Register  to view this content.

The file save is saving to a fixed file name so the copy will try and overwrite itself - and probably fail. Try this version

Please Login or Register  to view this content.

[dgavranovic]

Please Login or Register  to view this content.

This is how my file is copied and saved!
Now, what i want to do is, when you open a copy file, prompts you to put a password in before viewing the file!
And if i adjust the code above it makes the original file password protected rather than copy!

[tony h]

To save a file with macros you need a .xlsm file and also the right FileFormat as below

Please Login or Register  to view this content.

[timmatthews]

i think if im reading right you want the new file to be password protected so you can't open it without the password? try this.

Please Login or Register  to view this content.

[dgavranovic]

Thank you timmatthews!
It works!