Change To Read Only
When I send the Excel Workbook via email, it is automatically Read Only,
however, when the user opens the file and saves it, the file is no longer
read only.
I want to allow users of the program to edit cells, run macros, etc,
however, I do not want them to be able to save over the original Excel
spreadsheet that I originally sent.
How can I use VBA to automatically prompt (after running the macro) to Save
As - WITHOUT specifying a path/filename? I cannot have it automatically save
as a specific path because everyone's will be different (due to user names,
etc).
|