View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JCIrish JCIrish is offline
external usenet poster
 
Posts: 39
Default 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.