Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Save and Close Pop Up Box...After Save and Close In VBA


Thanks Tom.


I checked both the codes mentioned, but both were re-written as Sav
not SaveAs. The pop-up was still happening.

I hunted and hunted for the cause, but couldnt find it, Printed ever
code in the workbook, and there it was. A SaveAs command was running i
a Sheet_Deactivate code. Changed this to Save, and hey presto
Sorted.

I have nearly finished building this spreadsheet now.

Your name has been attached to the majority of the replies to m
questions, so may I thank you for all your assistance. I have tried
few other forums before, but never thought much of them, this on
however is absolutely fantastic.

Thanks Again.

Celtic_Avenger
:) :) :) :) :

--
Celtic_Avenge
-----------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php...fo&userid=1410
View this thread: http://www.excelforum.com/showthread.php?threadid=25896

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
save and close Mad Man Excel Discussion (Misc queries) 2 April 2nd 09 01:25 PM
Save/Close All M Scott Excel Discussion (Misc queries) 1 February 6th 07 01:12 AM
To save and close Steved Excel Worksheet Functions 5 July 27th 05 12:17 AM
Save and Close Pop Up Box...After Save and Close In VBA Celtic_Avenger[_12_] Excel Programming 3 September 11th 04 10:58 PM
Close without save Jesse[_5_] Excel Programming 3 May 7th 04 12:03 AM


All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"