Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
form option buttons - how can I make them accessible? | Excel Discussion (Misc queries) | |||
increase number in cell by one continuously... | New Users to Excel | |||
How to number all pages in all the worksheets continuously from 1. | Excel Discussion (Misc queries) | |||
Printing cells continuously | Excel Worksheet Functions | |||
Continuously scroll a spreadsheet on the display | Excel Discussion (Misc queries) |