View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keep It Simple Stupid Keep It Simple Stupid is offline
external usenet poster
 
Posts: 45
Default 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).