If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Macro" not available on "Tools" Menu
I want to create and run some macros but the Macro option is not visible on
the Tools menu. The Windows installer says it is installed, but it is not accessible. Any suggestions? I'm running Excel 2003 for students and teachers under XP Pro... |
#2
|
|||
|
|||
ToolsCustomizeToolbars.
Scroll to Worksheet Menu Bar and hit "Reset". Note: this will wipe out any customizations you may have made to this Toolbar. Gord Dibben Excel MVP On Sat, 26 Feb 2005 06:51:02 -0800, p trev p wrote: I want to create and run some macros but the Macro option is not visible on the Tools menu. The Windows installer says it is installed, but it is not accessible. Any suggestions? I'm running Excel 2003 for students and teachers under XP Pro... |
#3
|
|||
|
|||
And you showed all the options on that tools menu.
(If there's an arrow at the bottom of that list (under Tools), click on it to see if Macro appears.) If that's not it, I'd try: Tools|customize|toolbars tab|Select the worksheet menubar and click reset. If the arrow thing works, you may want to show all your menus with no delay... Tools|customize|Options Tab|check "always show full menus" p trev wrote: I want to create and run some macros but the Macro option is not visible on the Tools menu. The Windows installer says it is installed, but it is not accessible. Any suggestions? I'm running Excel 2003 for students and teachers under XP Pro... -- Dave Peterson |
#4
|
|||
|
|||
Thanks guys, with your guidance I managed to fudge a solution to the problem. Although the "macros" sub-menu that I relied on in my earlier version of Excel didn't come back automatically when I hit reset, I created the same effect by dragging and dropping from the customise menu that you referred me to. Thanks for the help, much appreciated |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
The Out of Office Assistant comand is missing from the tools menu. | jill | General Discussion | 1 | February 25th, 2005 09:42 PM |
"encountered a problem" message on menu tools customize | Ross Bennett | Installation & Setup | 1 | December 17th, 2004 10:24 AM |
Database Wizard - Visio Extras option is missing from Tools menu | Maggie | Visio | 2 | June 8th, 2004 05:27 PM |
Goal Seek Is Missing From My Tools Menu | Bob | Setting up and Configuration | 1 | December 17th, 2003 10:42 PM |