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).

Check out the Workbook_BeforeSave event. You can check the value of SaveAsUI
and set Cancel=true if required.
Also, Application.GetOpenFilename may be useful.

NickHK

"Keep It Simple Stupid" <(E-Mail Removed)> wrote
in message news:A64FEDD8-5D64-46C8-8F5F-(E-Mail Removed)...
> 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).