Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
keyboard shortcut for a macro | Excel Worksheet Functions | |||
Excel 2003 Format Painter - Keyboard Shortcut doesn't work! | Excel Discussion (Misc queries) | |||
What is the keyboard shortcut to insert a bullet in Excel 2003? | Excel Discussion (Misc queries) | |||
Keyboard Shortcut in Macro | Excel Discussion (Misc queries) | |||
Find Keyboard shortcut in a macro | Excel Programming |