Continuously accessible form

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

Is there a way to make a form with buttons on it float
over a sheet?

I want to be able to create new sheets and each time have
access to the same set of buttons, almost like having them
docked off to one side of the screen.

Is this possible? I have a form and I can load it and
all, but then you cannot manipulate the spreadsheet.

Thanks

Sharon
 
in Excel 2000 and later, you can show a userform as modeless which does what
you describe. (see help on the show command)

However, if you want to simulate a floating toolbar, as was previously
suggested, why not use a floating toolbar (or docked toolbar).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable right click with a difference 2
How do I find what is in a spreadsheet 4
Save Form Position on Close 4
application.activesheet, should I use it? 3
form buttons on sheet collapse on unhide - sometimes 5
ControlTip Text 2
Wookbook Update from User Form 8
Is this possible in Excel (User Form) 1

Back
Top