The resolution was to install the missing VBA component. The VBA component
is a shared feature and not part of the Excel installantion.

Thanks to everyone who repsonded.
John

"JLGWhiz" wrote:

If you tried all of the Trust Center options and it still does not respond,
then it is possible that when Excel was being installed, the VBA option was
not selected. If that is true, then it would require an uninstall and
re-install to select the VBA option during installation. But check with
someone you know who is computer savvy before going that route.

"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