Custom Toolbar
Tom Ulincy wrote:
If I email the file the user gets a Run
Time Error message when opening the workbook.
The way to use custom toolbars is:
a) attach the toolbar to your workbook (View / Toolbars / Customize /
Attach)
b) in your workbook's BeforeClose procedure (in ThisWorkbook module),
delete the toolbar from the user's customisation
Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error Resume Next
Application.Commandbars("MyBar").Delete
End Sub
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
|