Continuously accessible form
 

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

Continuously accessible form
 

Could you use a customised toolbar?


-----Original Message-----
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
.

Continuously accessible form
 

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).

--
Regards,
Tom Ogilvy

"SS" wrote in message
...
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