| Answers to Frequently Asked
Questions Here are some
of the frequently asked questions about Shortcut Manager for Excel and
their answers.
- Which versions of Microsoft
Excel
does Shortcut Manager for Excel support?
- I
am trying to load the addin but its not getting added to the Addins list.
What could be the problem?
- How do I configure my shortcuts?
- How
do I assign shortcuts to macros within my Excel file?
- I
am trying to assign shortcuts to macros in my Excel file. But I
don't see the Macros category. What could be the problem?
- Can
I assign shortcuts to my password protected VBA code?
- Does
"Clear All" button in "Customize Shortcuts" dialog
box affect the shortcuts defined by Excel?
- Where are the
shortcut definitions
stored?
Which versions of Microsoft
Excel does Shortcut Manager for Excel support?
Shortcut Manager for Excel is
supported on Microsoft Office Excel 2007, Microsoft Office Excel 2003,
Microsoft Excel 2002 (XP) and
Microsoft Excel 2000. Click here
to get more information about Shortcut Manager for Excel.
Back to top
How do I configure my shortcuts?
To assign keyboard shortcuts to menu items,
follow these steps:
- Select Add-Ins | Customize Shortcuts button in
Microsoft Office Excel 2007 or
Tools | Customize Shortcuts... menu item in previous
Microsoft Office Excel versions. On selecting this
menu item, you will be presented with Customize Shortcuts dialog. This
dialog enables you to configure the shortcuts.
- In the Customize Shortcuts dialog,
locate the appropriate category and the command in that category for
which you wish to assign a keyboard shortcut.
- In the Assign shortcut to command
box, press the key combination that you wish to assign to the selected
command.
- Click OK.
When the assigned key combination is
pressed, the corresponding set of commands will be executed.
Back to top
How
do I assign shortcuts to macros within my Excel file?
To assign keyboard shortcuts to macros within Excel files,
follow these steps:
- Open the Excel file.
- Select Add-Ins | Customize Shortcuts button in
Microsoft Office Excel 2007 or
Tools | Customize Shortcuts... menu item in previous
Microsoft Office Excel versions. On selecting this
menu item, you will be presented with Customize Shortcuts dialog. This
dialog enables you to configure the shortcuts.
- In the Customize Shortcuts dialog,
locate and select the Macros category. The macros in your
Excel file will be listed in the Commands list. Locate and select
the macro for
which you wish to assign a keyboard shortcut.
- In the Assign shortcut to command
box, press the key combination that you wish to assign to the selected
command.
- Click OK.
When the assigned key combination is
pressed, the corresponding macro will be executed.
Back to top
I
am trying to assign shortcuts to macros in my Excel file. But I don't
see the Macros category. What could be the problem?
This problem can be seen with Excel XP (also known as Excel
2002) and later releases. Excel introduces a new option that enables users to
disallow addins from using macros in Excel files. This option is
disabled by default. You need to enable this option for Shortcut Manager
to see the macros in the Excel file. To enable the option,
follow these steps:
| Excel 2007 |
Excel 2003, 2002, 2000 |
-
Select the Office Button or press Alt+F key combination.
-
Click Excel Options button.
-
Select Trust Center in the left pane.
-
Click Trust Center Settings button in the right pane.
-
Select Macro Settings in the left pane.
-
Make sure that Trust access to the VBA project object model is
checked.
-
Click OK buttons.
|
- Select Tools | Macro | Security... menu item.
- Select the Trusted Sources page.
- Make sure that Trust access to Visual Basic Project is
checked.
|
Back to top
Can
I assign shortcuts to my password protected VBA code?
Yes. You can assign shortcuts to password
protected VBA code. Shortcut Manager needs to access the macros only while
defining the shortcuts. Once the shortcuts are defined, then the key
combinations would work even if the VBA code is password protected and not
available for viewing. Follow these steps:
- Enable access to the VBA code by
supplying the password to the VBA editor.
- Assign the shortcuts using the Add-Ins | Customize Shortcuts
button in Microsoft Office Excel 2007 or
Tools | Customize Shortcuts... menu item in previous
Microsoft Office Excel versions.
- Save and close the presentation.
Now when you open this presentation again,
the defined shortcuts would work. You don't need to supply the password
while using the shortcuts.
Back to top
Does
"Clear All" button in "Customize Shortcuts" dialog box
affect the shortcuts defined by Excel?
The Clear All button in Customize
Shortcuts dialog box clears the shortcuts defined through Shortcut
Manager. It does not affect the shortcuts defined by Excel.
Back to top
Where
are the shortcut definitions stored?
For shortcuts to macros, Shortcut Manager
stores the shortcut definitions in the same file as the macros. For
shortcuts to menu items, Shortcut Manager uses the Windows Registry to
store the definitions.
Back to top
|
OfficeOne Shortcut Manager for Excel