Macro Buttons Fail in Excel 2007

[pete.trudell]

I have a very important spreadsheet used statewide for agency work.
We are moving to Vista and Office 2007 very soon, and I am testing our
Excel 2003 spreadsheets in Excel 2007 and have found that my Macro
Buttons do not activate. There must be a simple setting to allow this
function, but I have failed to find it, nor have I found an easy way
to get to Visual Basic in my spreadsheet.

Any help would be appreciated. Thank You

Pete

 

[Jim Rech]

The default installation of Excel 2007 does not include support for macros
or the VBE. If pressing Alt-F11 in Excel 2007 does not open the VBE, as it
should, then you might try re-running the Office 2007 setup being sure to
select Visual Basic for Applications under Office Shared Features.

--
Jim
|I have a very important spreadsheet used statewide for agency work.
| We are moving to Vista and Office 2007 very soon, and I am testing our
| Excel 2003 spreadsheets in Excel 2007 and have found that my Macro
| Buttons do not activate. There must be a simple setting to allow this
| function, but I have failed to find it, nor have I found an easy way
| to get to Visual Basic in my spreadsheet.
|
| Any help would be appreciated. Thank You
|
| Pete