Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbook with code that displays a user form when the workbook is
opened. I've also added (using the "Customize" option in "Excel Option's") a custom button to the Quick Access Toolbar that displays the same user form when clicked. How can I get the button to show on the quick access toolbar for this workbook only? Or, am I going about accomplishing these two things in the completely wrong way? The relevant VBA statements are simple: Sub Workbook_open() UserForm1.show End Sub and the macro behind the button on the quick access toolbar is Sub OpenFormFromToolbar() UserFrom1.show End Sub All help will be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Easy way to add my custom button on Excel 2010 quick access toolbar? | Excel Discussion (Misc queries) | |||
Quick Access Tool Bar won't save customization | Excel Discussion (Misc queries) | |||
How do I copy quick access tool bar to another computer? | Excel Discussion (Misc queries) | |||
Add Custom Button to Quick Access Toolbar | Excel Programming | |||
add text to the icons in the quick access tool bar | Setting up and Configuration of Excel |