share custom menus and toolbars across users

U

underhill

Hi,

This might seem to be a novice question so I apoligise in advance!

I have a macro which I have assigned to a toolbar icon and dropped int
the standard toolbar area (next to the save icon). Does anyone know ho
I can have this icon appear when users log in from their own machine?

thanks agai
 
B

BrianB

There is never any need to apologise.

1. You can make toolbars part of the workbook vi
Tools/Customize/Attach.
2. Save and close the workbook.
3. Delete or hide the toolbar in your Excel.
4. open the other workbook to test.
5. Put code like this into the Thisworkbook code module so the butto
is removed when it is closed :-

Code
-------------------

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("test").Delete
End Sub

-------------------
 
Top