Excel macro
 

We have a macro to produce a chart to list totals by machine number.
Code was added to prompt user if they want to save this to a file
first. I removed the code so that the macro just prompts for dates and
displays the chart. I don't get the message do you want to save but the
"save file as window" still comes up. Don't see in code what is making
this happen. Please help.
Thank You.


--
ednewbie
------------------------------------------------------------------------
ednewbie's Profile: http://www.excelforum.com/member.php...o&userid=35525
View this thread: http://www.excelforum.com/showthread...hreadid=552935

Excel macro
 

I don't see it either, but does your code close the workbook? If so try

ActiveWorkbook.Close SaveChanges:=False

if that isn't it, do you have something like

fname = Application.GetSaveAsFileName( . . . )
if so, then comment out that line.

--
Regards,
Tom Ogilvy

"ednewbie" wrote in
message ...

We have a macro to produce a chart to list totals by machine number.
Code was added to prompt user if they want to save this to a file
first. I removed the code so that the macro just prompts for dates and
displays the chart. I don't get the message do you want to save but the
"save file as window" still comes up. Don't see in code what is making
this happen. Please help.
Thank You.


--
ednewbie
------------------------------------------------------------------------
ednewbie's Profile:
http://www.excelforum.com/member.php...o&userid=35525
View this thread: http://www.excelforum.com/showthread...hreadid=552935