Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password protection
I have written/recorded code which takes one spreadsheet (FileA) and saves it
to another location under a different name (FileB). I want my code to also automatically give FileB a password of "test" so that when another user tries to open it, it will prompt them for the password. Thank you in advance for your help! Steve C |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password protection
Use ActiveWorkbook.SaveAs and look at the password arguments in help.
-- Regards, Tom Ogilvy "Steve C" wrote in message ... I have written/recorded code which takes one spreadsheet (FileA) and saves it to another location under a different name (FileB). I want my code to also automatically give FileB a password of "test" so that when another user tries to open it, it will prompt them for the password. Thank you in advance for your help! Steve C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protection in macro ( Anybody can view my password in VB | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
password protection | Excel Discussion (Misc queries) | |||
Password protection | Excel Discussion (Misc queries) | |||
Password protection | Excel Discussion (Misc queries) |