In EXCEL 2007 take the following action:-

- open the Workbook

- you should get a button towards the top of the screen called:-

Option . .

(to the right of the words:-

Security Warning Macros have been disabled).

- Click this Options button / select Enable this content / hit OK

- View / Macros group / Macros / View Macros /

- select the Macro you wish to Edit (by clicking on its name) and hit the
Edit button

- Microsoft Visual Basic editor should open

Please hit Yes if my comments have helped.

Thanks.


"Howard Brazee" wrote:

I have a spreadsheet that hasn't been changed since my work upgraded
my Office. I don't remember where they hid the part that shows what
version of Excel I have. But that's normal with this new Office
hardly anything I used to know how to find is hidden.

I need to change a VB macro, but the View/Macros did not show anything
and I know there is some VB in this spreadsheet. I saved this
spreadsheet from compatibility mode to a XSLM form, opened it again,
and still can't find the macros.

How do I get to the Visual Basic?

--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."

- James Madison
.