View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron[_9_] Ron[_9_] is offline
external usenet poster
 
Posts: 3
Default 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.


.