LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Excelerate-nl
 
Posts: n/a
Default Display message during save operation

Dear Experts,

I would like to display a message during a save operation of a sheet (it is
quite a large file so it takes a while).
There is another thing related to this: When a user starts this spreadsheet
without enabling the macro's, the workbook is opened with a sheet showing a
text box with the message "Please reopen with macro function on". In the
BeforeSave event macro I activate this sheet with the text box (so it will be
shown on next start up). However this results in the display of the text box
"Please reopen with macro function on" during a save operation (which is
quite confusing).

Please help,

Jan Bart
 
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
Display a message when a file is opened. Sheila New Users to Excel 4 November 15th 05 05:14 PM
How to save a file without overwrite or save a copy? SettingChange Setting up and Configuration of Excel 1 November 3rd 05 02:10 AM
Getting message can't save all data in excel xls file Melody05 Excel Discussion (Misc queries) 2 June 29th 05 12:20 PM
Display message based on condition Pat Excel Worksheet Functions 1 March 7th 05 10:52 PM
Combine & Display “Fixed” & “Automatically Updated” Date Parts texcel Excel Worksheet Functions 1 November 1st 04 05:38 PM


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