Excel 2010 VBA error when file opened from email

[GRCArizona]

Hi -

I've got a file that works fine on my computer. When I email it to anyone with 2010 and they open it from their email account (Outlook 2010), the file automatically opens up in 'Protected Mode'. If the user selects "Enable Editing" the user receives 'Run Time error 91: Object variable or with block variable not set'.

If the user closes out the vba error and saves the file to their computer and reopens the file, it works fine.

Anyone experience this or have any thoughts?

BTW, it is not a complex macro, it is error out at

ActiveWorkbook.Sheets("Worksheet").Select

Thx, GRC

 

[Jeffrey Smith]

I only have Outlook 2007 so I couldn't duplicate the error.