View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter[_21_] Peter[_21_] is offline
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