Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file ready only
I have code that on the Auto_Open it will run test to see if the file is read
only and if not then will make it ready only. The issue is that when you go to ready only it will ask if you want to save the file. I do not because I want the file only ready only from the beginning. What I did is make a second file and on the Before_Save I test the name of the file and if it is the name of the final file I am using I Cancel the Save. So I complete my setup file and then I go to windows and make a copy and name it my final file. So basically the user enters the file....in the Auto_Open it sets DisplayAlerts to False ... then changes file to ready only ... the file wants to save and since it is now the name of the file that I am testing and Cancelling in the Before_Save it will not save and will switch to ReadOnly with out saving and without displaying alerts. I also have cancelled out the SaveAs.. Is this the best way to handle this or is there a way to tell a file to open directly ReadOnly. Note: I do not want to do Recommend Read Only. I want the file to open and be forced to Read Only. Thank you, Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel says ready but blue Blank Screen stays on and file doesn't o | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Open a file do a macro ( made) and open next succesive file | Excel Programming | |||
Open File or Switch Between Windows if File is Open | Excel Programming | |||
Open File or Switch Between Windows if File is Open | Excel Programming |