Hi,
I've seen several answers out there when trying to suppress messages when opening an Excel file programmatically. But, I haven't seen a definitive reply to my specific scenario. Here it is. I have a file I want to put on a share. I want to have users (manually) open the file as read only, either by marking it as such, or by specifying the folder it is in as read only. I envision several users opening this file at a time and to interact with the various pivot tables I have in the file. That is, they would select different filter criteria and see the new results. No one would be saving the file.
First, I would like to disable the message that one gets when one already has the file open and then a 2nd person wants to open the file.
Second, I want to disable the automatic popup that one gets about having to enter a password (since the file is to be saved as requiring a password for modifications).
Note: if the file resides on a "read only" share, it may NOT need to be saved as requiring a password to open it for writing. In that case, requirement 2 goes away. However, requirement one is a must have since that will unfortunately, confuse our users.
Without opening the file programmatically, is there any way in Excel (I currently have 2013, but most users have 2010) to accomplish this? I can write VBA code to perform functions as necessary, but others have commented that the code won't run (even on Auto Open) until after the above messages have been displayed. If there is no way I can accomplish this without opening the file programmatically, that would be important to know too.
Many thanks in advance.
Scotty81
I've seen several answers out there when trying to suppress messages when opening an Excel file programmatically. But, I haven't seen a definitive reply to my specific scenario. Here it is. I have a file I want to put on a share. I want to have users (manually) open the file as read only, either by marking it as such, or by specifying the folder it is in as read only. I envision several users opening this file at a time and to interact with the various pivot tables I have in the file. That is, they would select different filter criteria and see the new results. No one would be saving the file.
First, I would like to disable the message that one gets when one already has the file open and then a 2nd person wants to open the file.
Second, I want to disable the automatic popup that one gets about having to enter a password (since the file is to be saved as requiring a password for modifications).
Note: if the file resides on a "read only" share, it may NOT need to be saved as requiring a password to open it for writing. In that case, requirement 2 goes away. However, requirement one is a must have since that will unfortunately, confuse our users.
Without opening the file programmatically, is there any way in Excel (I currently have 2013, but most users have 2010) to accomplish this? I can write VBA code to perform functions as necessary, but others have commented that the code won't run (even on Auto Open) until after the above messages have been displayed. If there is no way I can accomplish this without opening the file programmatically, that would be important to know too.
Many thanks in advance.
Scotty81
