When Save As stop running macro
Hi M K W,
If I understand you right, you want to be able to save the
workbook without updating cell(A1)?
Try the following VBA-code and activate it by a Shortcut
key:
Sub close1()
ThisWorkbook.Sheets(1).Range("A1") = Range("A1").Value - 1
ThisWorkbook.Close
End Sub
I hope this will do the trick!
Ron
-----Original Message-----
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.
.
|