use macro/keyboard shortcut/menu bar without changing normal.dot

[barbetta3141]

I'm trying to assign a keyboard shortcut to a macro, but I'm not
permissioned to modify my normal.dot file (work computer). I'm
assuming there is no way to use keyboard shortcuts without modifying
normal.dot, right?

What about adding a custom toolbar and button? It wouldn't be as fast
as a keyboard shortcut, but still better than
Alt-&Tools-&Macros-&Macros, select from list, Enter. Can I put a setup
procedure to create a toolbar and button in the document instead of in
normal.dot? Then when I open it, I could run the setup procedure to
add the toolbar with a button that points to the macro. Something
like:

Public Sub CreateDBToolbar()
CommandBars.Add(Name:="MyToolbar").Visible = True
'how do I add a button and have it point to MyMacro?
End Sub

Thanks.

 

[barbetta3141]

Couldn't find this on the newsgroup initially, but I figured out a
better search string and came across a post with the answer. Sorry to
post a question that's already been answered.