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

[jshaw82]

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

[6StringJazzer]

What error message do you get when the debugger halts there? Is is that you just don't want the error when opened from email, or do you don't want it to run at all?

I am not sure what's going on but I would give this a try to resolve the error. I am not sure how to detect that Excel was opened by opening an email attachment.

Please Login or Register  to view this content.

[shg]

Maybe ...

Please Login or Register  to view this content.

[jshaw82]

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?

[shg]

First line of your sub.

[jshaw82]

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

[shg]

How would that would relate?

[jshaw82]

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

[6StringJazzer]

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?

[jshaw82]

Hi Sorry - this is the error that comes up:

Please Login or Register  to view this content.

[6StringJazzer]

I don't know the answer but here's what I would do to debug. Insert the following line immediately before the line that is causing the error and let us know what comes up:

Please Login or Register  to view this content.

It's a wild guess.