| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel VBA open with Password
I have a file that I have changed the options to ask for password to
modify. But anyone can open the file as read only. I want to make changes with a macro to eliminate human error. I want the workbook to be protected but I need the code to open the file so it can make changes. How is this accomplished? I tried but this is if it has a password to open. Workbooks.Open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls", Password:="Jay" Thanks in advance, Jay |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forgotten OPEN password for Excel file??? | Excel Discussion (Misc queries) | |||
| How to open Excel spreadsheet when forgotten password | Excel Discussion (Misc queries) | |||
| I Lost my excel password How can I open it? | Excel Discussion (Misc queries) | |||
| I Lost my excel password How can I open it? | Excel Discussion (Misc queries) | |||
| Excel won't open it's a blank page, after password | Excel Discussion (Misc queries) | |||
Threaded Mode
