Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change To Read Only
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" wrote in message ... 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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a workbook from read only? | Excel Discussion (Misc queries) | |||
Don't change read only documents, or at least don't ask me about t | Excel Discussion (Misc queries) | |||
how can i change column to read a.b.c.etc and not 1.2.3. | Excel Discussion (Misc queries) | |||
Change Read-Only Recommended Prompt | Excel Programming | |||
My speadsheet won't change out of Read Only - Help!! | Excel Discussion (Misc queries) |