Access Macros in Office 2007 Beta 2

O

ordnance1

How does one access Macros in Office 2007 Beta 2? Unlike the old office there
is no Tools, Visual Basic to click on to bring you into the VBA editor.
 
H

Harlan Grove

ordnance1 wrote...
How does one access Macros in Office 2007 Beta 2? Unlike the old office there
is no Tools, Visual Basic to click on to bring you into the VBA editor.

That should be covered in the help files. [Excuse me as I laugh
uncontrollably.]

Seriously, does the [Alt]+[F11] key combination still switch between
Excel and the VBE?
 
N

Nick Hodge

You go to the Office button and select 'Excel Options' select the
'personalize' tab and then 'show developer tab in ribbon' This will give
you access to all the macro and VBA stuff and is obviously persistent...and
yes Harlan...Alt+F11 still works. (Unlike the help actually)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
O

ordnance1

Thanks for your time. That was what I needed.

Nick Hodge said:
You go to the Office button and select 'Excel Options' select the
'personalize' tab and then 'show developer tab in ribbon' This will give
you access to all the macro and VBA stuff and is obviously persistent...and
yes Harlan...Alt+F11 still works. (Unlike the help actually)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
Top