I've installed Excel 2007 on several PCs and written lots of macros in Excel 2007, and never had any problems. Today I installed it on a new PC. I've set macro security to enable all macros, and added the developer tab to the toolbar. However anything to do with VBA - record new macro, visual basic editor etc - is greyed out, as if I hadn't set the security option. I've closed and reopened Excel and the option is still set, I've rebooted, but it won't let e create new macros. Have I forgotten another setting somewhere?
Thanks
(Vista Premium, McAfee Internet Security installed)
Bookmarks