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.