quick access tool bar show/hide custom button on open/close workbo
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.
|