| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open password protected file with macros
I have a password write protected file which i want to open with macros...
How do I do it so it will not ask me for the password? I want others to open as read only so I force them pasword protecting my file but then I need to open it to write with macros.. please help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open password protected file with macros
you could unlock the cells they write to or unprotect and reprotect as you
run the code. Once protection is added to a worksheet, I think the code creation is much more tedious. "Alberto Ast" wrote: I have a password write protected file which i want to open with macros... How do I do it so it will not ask me for the password? I want others to open as read only so I force them pasword protecting my file but then I need to open it to write with macros.. please help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open password protected file with macros
Thanks Barb, I mean the file not a worksheet... I digged deeper into others
posts and find out what I needed. From Dave Peterson i got the following Workbooks.Open Filename:="C:\Settings.xls", _ Password:="1234", writerespassword:="qwer" "Barb Reinhardt" wrote: you could unlock the cells they write to or unprotect and reprotect as you run the code. Once protection is added to a worksheet, I think the code creation is much more tedious. "Alberto Ast" wrote: I have a password write protected file which i want to open with macros... How do I do it so it will not ask me for the password? I want others to open as read only so I force them pasword protecting my file but then I need to open it to write with macros.. please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PAssword protected file will not open | Excel Discussion (Misc queries) | |||
| How to delete a password in a protected file that you can't open? | Excel Discussion (Misc queries) | |||
| Macros will not run in a password protected file office 2007 pro | Excel Discussion (Misc queries) | |||
| Open file on password-protected FTP site | Excel Programming | |||
| Hyperlink to open password protected file? | Excel Programming | |||
![Alberto Ast[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
