Reset Custom Button on toolbar

J

Josh O.

I am running the below code...is it possible to have reset the two buttons I
added in the Sub Menu_Item macro to the active file name after a "Save As".
I keep getting an error saying that "The macro 'OriginalFileName!InsertLine'
cannot be found."

Private Sub Workbook_Open()
Call MenuBar_Item
Call DoF
End Sub

Private Sub MenuBar_Item()
Call MenuBar_Item_Delete
With Application.CommandBars("Standard")
With .Controls.Add(Type:=msoControlButton, ID:=2, Temporary:=True _
, Before:=1)
.Style = msoButtonIcon
.Caption = "&Spell Check"
.TooltipText = "Run Spell Check"
.OnAction = ThisWorkbook.Name & "!SpellCheck"
.Tag = "SpellCheck"
End With
With .Controls.Add(Type:=msoControlButton, ID:=295, Temporary:=True _
, Before:=2)
.Style = msoButtonIcon
.Caption = "&Insert Formated Line"
.TooltipText = "Run Insert Formated Line"
.OnAction = ThisWorkbook.Name & "!InsertLine"
.Tag = "InsertLine"
End With
End With
End Sub

Private Sub MenuBar_Item_Delete()
On Error Resume Next
Application.CommandBars.FindControl(Tag:="SpellCheck").Delete
Application.CommandBars.FindControl(Tag:="InsertLine").Delete
On Error GoTo 0
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call UndoDoF
End Sub

Private Sub DoF()
With Application
.OnKey "{F7}", "SpellCheck"
.OnKey "{F12}", "InsertLine"
End With
End Sub

Private Sub UndoDoF()
With Application
.OnKey "{F7}"
.OnKey "{F12}"
End With
End Sub
 
J

Josh O.

Nevermind...I found the error. I missed the line: "ThisWorkbook.Name & "
after the OnAction.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top