Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Toolbar
I created a custom toolbar (Excel 2002, Win XP) and it
works on my pc. If I email the file the user gets a Run Time Error message when opening the workbook. (Article 291068 Visible property does not apply to all commandbars - Can't move focus to the control because it is invisible, not enabled or of a type that does not accept the focus.) The MS knowledge base acknowledges this is a problem but does not seem to offer a solution. Is there a way to save/send a file so other's can use a custom toolbar? TIA Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom toolbar | Excel Discussion (Misc queries) | |||
Custom VBA toolbar | Excel Discussion (Misc queries) | |||
Custom Toolbar | Excel Discussion (Misc queries) | |||
Custom Toolbar | Excel Discussion (Misc queries) | |||
saving toolbar buttons on custom toolbar | Excel Programming |