Save

[Kas]

I need to write a macro that will assign a procedure to
the save button on the toolbar. Because of the way it
opens, I can't go to Tools - Customize - right-click on
the Save button, choose Assign macro. Is there code that
will do this?

Any help would be GREATLY appreciated.

 

[Roger Whitehead]

With Application.CommandBars("Standard").Controls(3)
.OnAction "NameOfYourMacroHere"
End With

You'll need a re-set code as well though.............

 

[Kas]

Unfortunately, that did not work.

-----Original Message-----
With Application.CommandBars("Standard").Controls(3)
.OnAction "NameOfYourMacroHere"
End With

You'll need a re-set code as well though.............

--
HTH
Roger
Shaftesbury (UK)








.