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: 35
Default refresh application.caption

Hello everyone,

(Problem in : Win 2k, Off 2k)

In almost all of my excel files that I use regularly in the office and at
home I have the Workbook_Open, -_Activate and -_Deactivate events programmed
to alternate between showing "Microsoft Excel" (for files that are not yet
saved) and the full path of the file as a the applications caption.

However, if I save an already saved file to a different location, lets say
memory stick designated as F:, the caption is not refreshed to F:\ [rest of
path] - [FileName]

How can I make shure that after such a save-action the application.caption
string is immediately refreshed as is intended?

Greetings,
Peter


 
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
Create refresh button in worksheet to refresh Pivot Table Data Ron Excel Worksheet Functions 1 October 13th 07 01:20 AM
Timing of automatic query refresh and macro pivot table refresh dutty Excel Programming 2 December 1st 04 07:19 PM
Empty keyword in statment Application.caption? Mel Excel Programming 6 July 31st 04 11:32 PM
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH Ken Roberts Excel Programming 3 September 11th 03 06:02 AM
Default Application.caption Soniya Excel Programming 1 August 12th 03 01:18 PM


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