Sorry I found the mistake.
I had not put a : before the = sign!
Its unusual to require that..I have used just = in many other situations and it works just
fine.
Best
John
John Baker wrote:
Jan:
The macro is as follows now and it STILL saves the spreadsheet! Any suggestions?
:
Sub InstallNo()
'
' InstallNo Macro
' Macro recorded 07/02/2004 by John H Baker
'
Msgbox ("You have elected not to install the new version of the spreadsheet. If you change
your mind you may reopen this sheet and restart the installation process later.")
ActiveWorkbook.Close SaveChanges = False
'
End Sub
Jan Karel Pieterse wrote:
Hi John,
ActiveWorkbook.Close Save = False
I had anticipated that this wold result in the spreadsheet being closed but NOT being
saved. However, it appears that its being saved as its being closed.
Can someone suggest a reason, and more important, a way to prevent it being saved!
The proper syntax is:
ActiveWorkbook.Close SaveChanges:= False
Regards,
Jan Karel Pieterse
Excel MVP
www.jkp-ads.com