"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.