Macro-enable Workbook

[Salza]

In Excel 2007, I saved my workbook as 'Macro-enabled Workbook' file
type.

The icon that appears for this file then will be the normal Excel icon
plus the 'exclamation mark' sign in yellow on top of it. Is this
normal? Any problem for other people to open this file on their
computer?

I appreciate your kind advice. Thanks.

Salza

 

[Gord Dibben]

The exclamation mark is normal.............alerts user to filetype.

Opening on another computer will depend upon their security settings.

These can be accessed through Button>Excel Options>Trust Center.


Gord Dibben MS Excel MVP

 

[Salza]

The exclamation mark is normal.............alerts user to filetype.

Opening on another computer will depend upon their security settings.

These can be accessed through Button>Excel Options>Trust Center.

Gord Dibben  MS Excel MVP

Hello Gord Dibben,

I have enabled the macro in Excel 2007 on another computer. But when I
click on a button that I assigned macro with, it says the macro has
been disabled.
Any idea why does this happen?

 

[Gord Dibben]

I can't see your security and trust center settings so I'll assume you have
checked "enable with notification"

Excel may have disabled the macros on its own.

See if the workbook with macros has been disabled.

Excel 2002-2003: Help>About MS Excel>Disabled items

Excel 2007 : Office button>Excel Options..Add-ins
In the "Manage:" dropdown (bottom of the
dialog)
Choose "Disabled Items
Go

If the workbook is listed try to re-enable.


Gord