Hi all, should be quite a simple one but I'm struggling and most of the results on the web are very unhelpful.
I have a macro spreadsheet that I run on demand every day at 7am. When I come in at 8am I often see that it is sat telling me 'Your Spreadsheet.xls is locked for editing by User' and gives me the option to open Read-Only. I 100% want to run it Read-Only but can't find the correct switches/arguments to achieve this..
Using Windows Server 2008, the Action is to start a program "\\ourserver\sharedfolder\myfile.xls"
I tried putting r (no quotes or anything) in the arguments box also tried putting /r after the .xls and made no difference either.
Hope someone can help
Thanks
John
Bookmarks