General discussion

Locked

Custom Toolbars in Excel Template

By mckay_w ·
I save a custom toolbar into my excel template, but when i open excel to a blank document, it also is saved in there also.
How do i get it to save into my template.
Any ideas.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Custom Toolbars in Excel Template

by DKlippert In reply to Custom Toolbars in Excel ...

Create the Toolbars on the fly. Here's some sample code from the forums:

Sub Auto_Open()
CreateToolbar
End Sub

Sub Auto_Close()
RemoveToolbar
End Sub

Sub CreateToolbar()
Set CabDocBar = CommandBars _
.Add(Name:="CabDoc", Position:=msoBarFloating, _
Temporary:=True)
With CabDocBar
.Controls.Add Type:=msoControlButton, ID:=2
.Visible = True
End With
End Sub

Sub RemoveToolbar()
For Each bar In Application.CommandBars If Not bar.BuiltIn Then bar.Delete
Next
End Sub

Collapse -

Custom Toolbars in Excel Template

by mckay_w In reply to Custom Toolbars in Excel ...

just had to go to customise, and attach the toolbar to that workbook

all done

Collapse -

Custom Toolbars in Excel Template

by mckay_w In reply to Custom Toolbars in Excel ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums