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: 276
Default msgbox to NOT display OK Button and to run while saving?

With the code below i want to see if i can have the file SAVING WHILE the
msgbox is being displayed, not
to START Saving once the KK button is clicked.

Is this possible??

Code(Part of):
res = MsgBox("Saving file this file may take a few Seconds, Please
wait....", , "Msgbox Title")
ActiveWorkbook.Save ' <========== Want this to occur DURING the msgbox being
Displayed, AND no OK Button on the MsgBox.
Application.Quit
End Sub

regards

Corey....


 
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
code to close an excel sheet without saving it .(via msgbox) Satyam Reddy Excel Worksheet Functions 2 May 14th 08 02:48 PM
How to display remaining txt file which overflowed MsgBox display? EagleOne Excel Discussion (Misc queries) 1 November 2nd 06 01:10 PM
MsgBox Display Michael S. Excel Programming 2 June 16th 05 10:55 PM
Display of $ in Msgbox David Excel Programming 2 September 8th 04 09:38 AM
Display MsgBox thru automation Per-Olof Excel Programming 1 January 13th 04 07:39 AM


All times are GMT +1. The time now is 10:16 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"