Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / August 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
barbetta3141@yahoo.com - 23 Aug 2006 18:11 GMT
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@yahoo.com - 23 Aug 2006 18:23 GMT
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.

> 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
[quoted text clipped - 15 lines]
>
> Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.