Thanks for your input. I have just got to the bottom of this with technical
support and it appears to be an encryption issue. In .xlsm format if you
password protect your file the macros will not run. So if you want a password
protected file with macros that will run you still have to save as 97-2003
workbook.

It is a software issue they have become aware of and apparently will correct
on future updates.

"Jon Peltier" wrote:

If Run is not grayed out, it means you can run the macros, the macros are
enabled. If the other options are grayed out, the VB project is password
protected, and you are not allowed to view the code. I couldn't get Step
Into to be enabled without the other editing buttons also to be enabled.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Graham" wrote in message
...
I know the bar you're referring to as it was appearing before I converted
to
.xlsm. I have just tried your suggestion and still the same whether I
choose
that option or 'Enable all macros' and the bar doesn't appear. Could it be
hidden somewhere?

When I open the macro dialogue box in 'View Macros' they are all listed
but
all options other than 'run' and 'step into' are greyed out.

GM


"Jim Rech" wrote:

If you have macro security set to "Disable all macros with notification"
then after you open a workbook with macros you should see a "Security
warning" bar appear above the Formula bar. It has an Options button that
you can use to enable macros.

--
Jim
"Graham" wrote in message
...
| I've looked through all the macro posts and can't solve this. I
converted
my
| .xls file to .xlsm (macro-enabled workbook) but still can't get the
macros
to
| operate.
|
| I get the message 'Because of your security settings, macros have been
| disabled. To run macros, you need to reopen this workbook, and then
choose
to
| enable macros.'
|
| I have enabled all macros in the Trust Center and the VB tab shows the
macro
| code.
|
| Anu suggestions?