Inransigent ToolTip

[Sophia]

I have a macro that's invoked by entering an AutoText name into a
document, then pressing F3, which opens a UserForm. When the AutoText
name is entered into the document, a ToolTip pops up (as expected).

Entries are made into the UserForm fields, and when a command button
"OK" is clicked, data from the UserForm fields is inserted into
bookmarks in the AutoText entry in the document and the UserForm is
hidden.

The &%$#* ToolTip remains visible on the screen after that. I want it
to just GO AWAY.

As I open the UserForm, I set Application.ScreenUpdating = True
Just before the UserForm is hidden, I do Application.ScreenRefresh.

The ToolTip remains visible until you press any key, or click the
mouse, then it disappears.

Help!!!!!

 

[Word Heretic]

G'day Sophia <[email protected]>,

Answered in vba.general

Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


Sophia reckoned: