I am not sure if this is an issue with the way Outlook is setup or something in my Excel macro.
When the Excel file is attached to an email and then the email is opened, the email opens in a protected vew with "Enable Editing" button. When this button is clicked following msg appears.

Run-time error '91':
Object variable or With block variable not set

Pressing "End" here, opens the Excel file and everything works fine.

When the same file is opened from the folder where it is saved, no message appears and everything works fine.

I' appreciate if anyone has more information on if / how the Excel files are treated differently when opened from folders v/s opened via Outlook.

Thx,
modytrane