Preventing "Workbook_Open" running when a file is opened from email

I have a "Workbook_Open" running in a file however when the file is opened from an email, it always fails when the user clicks "enable editing".

I still want it to run when you open the file normally but not when you open from an email. Anyone know how to stop this, or have a look at my code why it doesn't run when you open it in an email (i have underlined the code the debugger highlights)?

Please Login or Register  to view this content.

Thanks for any help

John

Hi Jeff, It selects the cell but doesn't show it. I have the top row pane froze, so if your scrolled elsewhere in the sheet it selects the cell but the previous code showed the cell too.

shg, where would your bit of code go?

Hi SHG - That still doesn't work. Its because the file is read only, is where I think the problem lies.

I dont know but its only when I open the file from Outlook (and enable editing) that I get the error. It says Read Only at the top

A file opened from an Outlook email will be read only, and it may also be opened in Protected Mode depending on your security settings. Read Only mode will not prevent macros from running but Protected Mode will unless the user enables macros upon opening.

When you say it doesn't work, do you mean the code doesn't run, or that it runs and still gives the error?

Hi Sorry - this is the error that comes up:

Please Login or Register  to view this content.