Floating toolbar (no, not the usual question)

[GlennLGillies]

Good evening all. I have not posted here for some time because I utilise the fantastic search function (site:MrExcel.com etc) all the time, and this has always been able to help me, till this one.

I have a floating toolbar (which i have learnt and adapted to my own needs from the input at this site), but, I would like to know is there any code, that allows it to hover (as it aways does) but allows the user to continue working on the spreadsheet while it is there?

Perhaps, I did not ask the right question in my searches, but I thought I exhausted all variables.

Thank you to all in advance
Glenn L Gillies

 

[Gary McMaster]

that allows it to hover (as it aways does) but allows the user to continue working on the spreadsheet while it is there?

This seems to imply that your "floating toolbar" might actually be a user form. If it is a user form you could try setting the form's "ShowModal" property to false.

Gary

 

[GlennLGillies]

Thank you Gary for your reply.

Burnt the candle at both ends last night (all night) and still could not get anything to work.

But (and here is one for all 2011 users), straight from excel 2011 vba help!

A userform in 2011 cannot be modeless!

Show Method (Visual Basic for Applications)
See Also Example Applies To Specifics

Displays a UserForm object.

Syntax

[object.]Show

The optional object is an object expression that evaluates to an object in the Applies To list. If object is omitted, the UserForm associated with the active UserForm module is assumed to be object.
Remarks

If the specified object isn't loaded when the Show method is invoked, Visual Basic automatically loads it.

A UserForm is always modal; therefore, the user must respond before using any other part of the application. No subsequent code is executed until the UserForm is hidden or unloaded.

Although other forms in the application are disabled when a UserForm is displayed, other applications are not.

Once again, thank you for your assistance Gary
Thank you
Glenn L Gillies

 

[Gary McMaster]

Glenn,

Thanks for the tip. I have a couple apps that are using a modeless form. I can hardly wait to upgrade and break them

Gary