Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When Save As stop running macro
I have a macro that changes the attributes of an Excel file when I open the
file, from read only to readwrite, then increment a cell (A1) by one, save the file then changes the attribute back to read only so that when I make changes to the file I should Save As and not save it and overwrite the original one. The problem is that when I save the file, if I decided to open the new file to review, the macro will run again and will increment A1. What shall I do so that when the user Save As the file, the macro wont be saved in the new file, or it wont run when the user reopen the file to review. Any help would be higly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop Macro running when I save the workbook | Excel Worksheet Functions | |||
Save To Csv Running A Macro | Excel Discussion (Misc queries) | |||
How do I stop a Macro from running? | Excel Worksheet Functions | |||
How to stop getting the file save box when running a macro | Excel Discussion (Misc queries) | |||
How to Pause or Stop a running Macro | Excel Programming |