refresh application.caption
Peter,
Problem here, as the only Save event you could trap is BeforeSave, and at
that point the path is still not known. The only thing I could think of is
if you have multiple windows to activate another and then return to the
original, forcing the activate event to fire.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Peter" wrote in message
...
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
|