Macro Buttons Fail in Excel 2007

  • Thread starter Thread starter pete.trudell
  • Start date Start date
P

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
 
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
 
Back
Top