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?

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?

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?

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?

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?

Ah, yes, now I remember this problem. There is a registry key that fixes
this. Under:

HKCU\Software\Microsoft\Office\12.0\Excel\Security

add this new Dword key and set its value to 1.

ExcelBypassEncryptedMacroScan

(Run the RegEdit.exe program to do this.)

--
Jim
"Graham" wrote in message
...
| 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?
|
|
|
|
|
|

I did just what you described, and the macro in my protected VB project ran
just fine. And I don't have Jim's registry hack installed.

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


"Graham" wrote in message
...
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?