I cant find the one JLGWhiz refers to under Trusted Publishers pane but
there is a similar one under Macro Settings €œTrust access to VBA object
model€�. However, unchecking that does not disable the VBA editor.

Only clutching at straws and I dont intend to test it but I dont suppose
you have removed or disabled any of the default Trusted locations? By default
there should be 6 trusted locations and one or more of these may be required
for the VBA editor. Under the description they a-

Excel 2007 default location: User templates
Excel 2007 default location: Excel Startup
Excel 2007 default location: User Startup
Excel 2007 default location: Application Template
Excel 2007 default location: Office Startup
Excel 2007 default location: Add-ins

In the same dialog box ensure that box is unchecked against €œDisable all
trusted locations. Only files signed by Trusted Publishers will be trusted€�

If you have deleted the trusted locations and now dont know the path for
them then let me know and Ill post them for you.

--
Regards,

OssieMac


"JLGWhiz" wrote:

In the "Trusted Publishers" pane there is a check box for "Trust Access To
Visual Basic". Make sure that is also checked.

"John" wrote:

I can not access the VBA Editor as it is greyed out. I have double-check
settings relative to the Excel Options in the Trust Center to ensure the
Macro Settings are enabled and the Developer Macros Settings is checked.

Does anyone have any ideas as to why?

Thanks,
John