Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 89
Default Get rid of SaveAs prompts

On Aug 14, 2:51*pm, Bongard wrote:
It prompts me he

ActiveWorkbook.Close SaveChanges:=True '(It continues
to prompt me here on a couple workbooks)

I don't know if anyplace where I have date or time functions in the
workbooks.

Thanks,
Brian


Change the Save Changes to False.

If you want to save it as the same workbook and the same name use
ActiveWorkbook.Save
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 Prompts PMOPS Excel Worksheet Functions 1 August 26th 08 05:40 PM
Saving Prompts Colin Hayes Excel Worksheet Functions 2 March 14th 07 03:02 PM
Prompts Carrguy Excel Programming 2 July 13th 06 06:06 PM
Prompts sdmccabe Excel Discussion (Misc queries) 1 April 13th 06 06:03 PM
Save without prompts Jeff Excel Programming 1 February 1st 05 03:22 PM


All times are GMT +1. The time now is 06:50 PM.

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

About Us

"It's about Microsoft Excel"