Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password Protect Workbook via code
Couldn't seem to find this in Google.
Hopefully, it's possible..... Scenario: Macros are enabled Someone other than an authorized user has opened the workbook. One critical sheet of the workbook is copied to a newly created workbook (all of the above I can accomplish) I want to save that newly created workbook with a "Password to Open" I'll then close that workbook and delete the original one completely. Understood that it's futile to attempt this but for my particular audience it should work. Thanks, John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password Protect Workbook via code
Couldn't seem to find this in Google.
I guess I didn't search hard enough the first time. Found what I was looking for. Thanks Dave. John John Wilson wrote: Couldn't seem to find this in Google. Hopefully, it's possible..... Scenario: Macros are enabled Someone other than an authorized user has opened the workbook. One critical sheet of the workbook is copied to a newly created workbook (all of the above I can accomplish) I want to save that newly created workbook with a "Password to Open" I'll then close that workbook and delete the original one completely. Understood that it's futile to attempt this but for my particular audience it should work. Thanks, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fluent UI and protect workbook with password | Excel Discussion (Misc queries) | |||
Code to protect/unprotect a sheet using a macro with password | Excel Discussion (Misc queries) | |||
Password Protect a Workbook ? | New Users to Excel | |||
password protect workbook | Excel Discussion (Misc queries) | |||
password protect vba code | Excel Discussion (Misc queries) |