Excel 2007 Help
 

I have recently upgraded to Excel 2007.

Naturally things are a bit different and I am working through them. But 2
things I can't find. How do I add a menu option so I can list all my macros
and 2 In 2003 there used to be a box you could click on to instantly go to
nakmed ranges. Where do I find this?

Also is there discussion page solely for Excel 2007 changes?

Thanks
Rick

Excel 2007 Help
 

"Rick" wrote in message
...
I have recently upgraded to Excel 2007.

Naturally things are a bit different and I am working through them. But 2
things I can't find. How do I add a menu option so I can list all my
macros

Click on View tab, and at the far right-hand side click on Macros...


and 2 In 2003 there used to be a box you could click on to instantly go to
nakmed ranges. Where do I find this?


The box is where it's always been, to the left of the formula bar....

Also is there discussion page solely for Excel 2007 changes?

Nope.

Excel 2007 Help
 

Gordon wrote:
"Rick" wrote in message
...
I have recently upgraded to Excel 2007.

Naturally things are a bit different and I am working through them. But 2
things I can't find. How do I add a menu option so I can list all my
macros

Click on View tab, and at the far right-hand side click on Macros...


and 2 In 2003 there used to be a box you could click on to instantly
go to
nakmed ranges. Where do I find this?


The box is where it's always been, to the left of the formula bar....

Also is there discussion page solely for Excel 2007 changes?

Nope.

To add to Gordon's reply, once you find the icon you can right click on
it and add it to your quick access tool bar and it will display above
your ribbon.

gls858

Excel 2007 Help
 

Try this if you want it easy
http://www.rondebruin.nl/qat.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Rick" wrote in message ...
I have recently upgraded to Excel 2007.

Naturally things are a bit different and I am working through them. But 2
things I can't find. How do I add a menu option so I can list all my macros
and 2 In 2003 there used to be a box you could click on to instantly go to
nakmed ranges. Where do I find this?

Also is there discussion page solely for Excel 2007 changes?

Thanks
Rick

Excel 2007 Help
 

The named ranges I couldn't find because I didn't have any so that is sorted
thank.

However, with the macros issue I have the shortcut on my tool bar OK to view
any macros on open spreadsheets, but on Xl2003 I had a menu for all my
macros. How do I create the menu to attached them and run them directly.

Thanks


"Gordon" wrote:

"Rick" wrote in message
...
I have recently upgraded to Excel 2007.

Naturally things are a bit different and I am working through them. But 2
things I can't find. How do I add a menu option so I can list all my
macros

Click on View tab, and at the far right-hand side click on Macros...


and 2 In 2003 there used to be a box you could click on to instantly go to
nakmed ranges. Where do I find this?


The box is where it's always been, to the left of the formula bar....

Also is there discussion page solely for Excel 2007 changes?

Nope.

Excel 2007 Help
 

"Rick" wrote in message
...
The named ranges I couldn't find because I didn't have any so that is
sorted
thank.

However, with the macros issue I have the shortcut on my tool bar OK to
view
any macros on open spreadsheets, but on Xl2003 I had a menu for all my
macros. How do I create the menu to attached them and run them directly.


From excel 2007 Help:
Run a macro
1.. If the Developer tab is not available, do the following to display it:
1.. Click the Microsoft Office Button , and then click Excel Options.
2.. In the Popular category, under Top options for working with Excel,
select the Show Developer tab in the Ribbon check box, and then click OK.
Note The Ribbon is a component of the Microsoft Office Fluent user
interface.

2.. To set the security level temporarily to enable all macros, do the
following:
1.. On the Developer tab, in the Code group, click Macro Security.


2.. In the Macro Settings category, under Macro Settings, click Enable
all macros (not recommended, potentially dangerous code can run), and then
click OK.
Note To help prevent potentially dangerous code from running, we
recommend that you return to any one of the settings that disable all macros
after you finish working with macros. or more information about how to
change the settings, see Change macro security settings in Excel.

3.. Open the workbook that contains the macro.
4.. On the Developer tab, in the Code group, click Macros.
5.. In the Macro name box, click the macro that you want to run.
6.. Do one of the following:
a.. To run a macro in an Excel workbook, click Run.
Tip You can also press CTRL+F8 to run the macro. You can interrupt
the execution of the macro by pressing ESC.

b.. To run a macro from a Microsoft Visual Basic module, click Edit, and
then on the Run menu, click Run Sub/UserForm , or press F5.