Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have a file that is protected with a password required to modify. When my macro goes to open the file I receive a dispaly alert that it is recommended that the file is opened read only with three options to choose from; yes, no, cancel. Yes is the default but I want the macro to select NO. How can I do this? Please see the line of code below Workbooks.Open Filename:=MyFile, WriteResPassword:=My_PW -- Thank you Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Timed Display Alert | Excel Programming | |||
Display alert if data exists | Excel Programming | |||
Display alert problem | Excel Programming | |||
Display Alert | Excel Programming | |||
Display an Alert popup. | Excel Programming |