Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Empty keyword in statment Application.caption? | Excel Programming | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
Default Application.caption | Excel Programming |