bpeirson
Structural
- Apr 7, 2003
- 147
How can I set up Excel to open a workbook as read-only without any warnings or prompts.
The situation is this, whenever Excel is opened on any computer in our network it opens a copy of "openme.xls" because a shortcut has been placed in the xlstart folder.
There is only one copy of "openme.xls" which resides on drive C: of computer "First to start".
When a second computer starts excel and "openme.xls" is opened the user is prompted to select "openme.xls" as a read-only or as notify. How do I force excel to open "openme.xls" as read-only without prompting the user?
Bear in mind that the command to open the "openme.xls" is not initiated by the user therefore he can not simply "Open Read Only" from the open dialog.
Thanks for any suggestions
The situation is this, whenever Excel is opened on any computer in our network it opens a copy of "openme.xls" because a shortcut has been placed in the xlstart folder.
There is only one copy of "openme.xls" which resides on drive C: of computer "First to start".
When a second computer starts excel and "openme.xls" is opened the user is prompted to select "openme.xls" as a read-only or as notify. How do I force excel to open "openme.xls" as read-only without prompting the user?
Bear in mind that the command to open the "openme.xls" is not initiated by the user therefore he can not simply "Open Read Only" from the open dialog.
Thanks for any suggestions
