I am a newbie to VBA. I have created a userform which I want to use a floating toolbar i.e. a userform which floats on the screen, does not have a red x in the corner to close it and I can use the rest of the spreadsheet (apart from the userform) while the userform is being displayed. Is there any way to do this?

You can display the user form as modeless (Set Modal = False in Userform-->Properties window). This will make sure that you can work on Excel, when userform is shown

There is no direct way to remove/disable the close button on userform. You can try using API Functions (http://vbadud.blogspot.com/2007/08/d...rform-vba.html)

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)