VBA in excel 2007

EL_Loco

Hello,

i've written some vba for excel 2000 which was working fine. Some users have upgraded to excel 2007 and now they don't work. Excel 2007 goes into compatibility mode and I can't track down where to bring up the VBA editor in excel 2007.

I appreciate it's probably quite straightforward and I'd usually investigate myself but I'm a bit stuck for time.

Thanks in advance.

brianmc

EL_Loco wrote: »

Hello,

i've written some vba for excel 2000 which was working fine. Some users have upgraded to excel 2007 and now they don't work. Excel 2007 goes into compatibility mode and I can't track down where to bring up the VBA editor in excel 2007.

I appreciate it's probably quite straightforward and I'd usually investigate myself but I'm a bit stuck for time.

Thanks in advance.

Alt + F11
?

Ginger

http://office.microsoft.com/en-us/excel/HA101736551033.aspx#11

Or as BrianMc said alt+f11

EL_Loco

thanks chaps,

There's a security setting for macros in excel 2007 so when you allow access your scripts/VBA code should work from previous versions of excel; but by default it seems the security settings don't allow it.