After upgrading to Office 2010, when my Excel files are downloaded from the Internet or opened as Office 2010 email attachments, after selecting the option to "Enable Editing" we get the following error message: "Run-time Error '91': Object Variable or With block Variable not Set".
This is only occurring in files where I have Worbook_Open code so I am sure it is a security issue. I do not have the problem when opening files with Office 2007, only 2010. I don't believe it is actually a problem with the code because all files do this even when some of the code simply turns on automatic calculations when opened.
When debug is selected it just stops at the first line of the code. I added error checking to resume next, but then it just goes to the next line. Disabling macros in Office is not an option.
Thanks in advance for your help.