LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 84
Default Macro Button and Closing Excel

I created a Macro Button that I placed in the standard group of buttons and I
assoicated a Macro with it. Later I started Excel with a blank workbook. I
pushed the new macro button and the macro worked. It also opened the excel
workbook (Lift Logger) where the macro is stored. When I went to close the
Lift Logger workbook, I was asked, "Do you want to save the changes you made
to 'Lift Logger.xls'?

Well I did not make any changes to Lift Logger.xls? But more importantly,
1) Is there a way to surpress the opening of the Lift Logger.xls when I run
the macro in this manner? 2) Can I surpress the close message box?

If both or one are true, how and where do I put the code. It must be in the
macro some place. Please be aware that I am displaying some msgboxs in my
macro.

Thanks for your help.
 
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
Closing an Excel Spreadsheet via command button [email protected] Excel Programming 1 February 15th 08 04:45 PM
Closing excel from a macro maliaf Excel Programming 4 May 2nd 06 12:33 AM
Closing excel with a macro TJexcel Excel Programming 1 December 8th 04 07:42 AM
Closing Excel from a Macro Jimmy Excel Programming 6 August 20th 04 02:25 AM
Closing Excel down with a macro? andycharger[_28_] Excel Programming 2 May 6th 04 04:18 PM


All times are GMT +1. The time now is 08:09 AM.

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"