EconSean
Board Regular
- Joined
- Apr 21, 2002
- Messages
- 129
I was wondering if someone could instruct me on how to force Excel to open a file as read-only.
I tried this in the Autpen sub, but the user is still prompted (I don't want them to be able to click "No" when asked if they should open as read only, I want the "Yes" forced on them.):
Application.DisplayAlerts = False
I hope this makes sense. Thanks in advance for any hints.
Regards,
Sean
I tried this in the Autpen sub, but the user is still prompted (I don't want them to be able to click "No" when asked if they should open as read only, I want the "Yes" forced on them.):
Application.DisplayAlerts = False
I hope this makes sense. Thanks in advance for any hints.
Regards,
Sean