LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Assigning global macro to keyboard shortcut in Excel 2003

I hope you all can help me out! I've spent a few hours (this time)
trying to figure out how to:
1. Make a macro available in all spreadsheets that I create or open
2. Bind this macro to a keyboard shortcut.
I had this running with an older version of office, but after
upgrading, I just can't make it happen again.

Here's where I am:
- Deleted all personal.xla and personal.xls files
- Recorded a keyboard macro to recreate personal.xls in the right
place
- Unhid personal.xls so that I could work with it.
- Opened personal.xls, went to the VB editor, and pasted in the macro
I want, "OpenSCR"
- Saved personal.xls, exited excel, restarted.
- Went to Tools-Macro...-Macros
- Selected my OpenSCR Macro
- The darn Options... button is disabled, so I can't bind it to a key.
I've tried various combinations of hiding and unhiding personal.xls,
but I just can't get the thing enabled!

I'd really appreciate any ideas or suggestions.

Thanks,
Bob
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
keyboard shortcut for a macro Gary[_2_] Excel Worksheet Functions 3 October 24th 07 07:25 PM
Excel 2003 Format Painter - Keyboard Shortcut doesn't work! David Biddulph Excel Discussion (Misc queries) 0 February 21st 07 08:11 AM
What is the keyboard shortcut to insert a bullet in Excel 2003? Winnland Excel Discussion (Misc queries) 1 April 24th 06 06:18 PM
Keyboard Shortcut in Macro osaka78 Excel Discussion (Misc queries) 3 January 16th 06 08:47 AM
Find Keyboard shortcut in a macro AuthorizedUserPF[_2_] Excel Programming 4 February 17th 04 04:06 AM


All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"