View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Macro Shortcut Key

Set the Security level to low/medium in (Tools|Macro|Security). Goto menu
ToolsMacroMacrosOptions. Select the Macro and then assign a key

If this post helps click Yes
---------------
Jacob Skaria


"Derek Johansen" wrote:

Hey guys, I'm hoping someone can give me a hand here.

I have a very simple format and print macro that I wrote that needs to be
ran frequently. I want to assign a shortcut key to it. I have tried
everything I can think of for combinations, and nothing seems to run. When I
press the shortcut key, i get the famous microsoft "dong" sound or whatever
you call it! Does anyone have any idea what's going on with this?