I need to display a constant message to users reminding them of the control
keys to run macros on various worksheets within the same workbook. I've
designed the text on multiple user forms that show/hide modeless as the users
navigate from worksheet to worksheet.

However, the userforms always take focus when shown. Is there anyway to
show the forms and then have the worksheet automatically take focus so the
forms always "float" on top of the worksheets? Or is there a better way to
accomplish this other than userforms?

If there are not too many macro's you could use the Excel statusbar for your
messages.

RBS


"RaiderRed" wrote in message
...
I need to display a constant message to users reminding them of the control
keys to run macros on various worksheets within the same workbook. I've
designed the text on multiple user forms that show/hide modeless as the
users
navigate from worksheet to worksheet.

However, the userforms always take focus when shown. Is there anyway to
show the forms and then have the worksheet automatically take focus so the
forms always "float" on top of the worksheets? Or is there a better way
to
accomplish this other than userforms?

I hadn't thought of the commandbar option. Thanks for all of your
suggestions/options.


"keepITcool" wrote:


hmm..
you could use a commandbar iso a userform?
that'll float, can be easily hidden and repositioned.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


RB Smissaert wrote :

If there are not too many macro's you could use the Excel statusbar
for your messages.

RBS


"RaiderRed" wrote in message
...
I need to display a constant message to users reminding them of the
control keys to run macros on various worksheets within the same
workbook. I've designed the text on multiple user forms that
show/hide modeless as the users
navigate from worksheet to worksheet.

However, the userforms always take focus when shown. Is there
anyway to show the forms and then have the worksheet automatically
take focus so the forms always "float" on top of the worksheets?
Or is there a better way to
accomplish this other than userforms?