Unprotect method fails except on step through

[smokebreak]

I have a worksheet with a linked table and with the following code in it:

Please Login or Register  to view this content.

It works fine on step through, but watching the code run fired from a button or from the developer menu, it never unprotects the sheet which is presumably why it fails to refresh.

Unfortunately, I can't post the sheet because it contains a lot of sensitive data and I'm not sure how to anonymize it properly while maintaining the characteristics of the original sheet (lookups, linked tables, etc). Can any forum watchers help?

[Leith Ross]

Hello smokebreak,

Sheets("Input") must be the active sheet when the macro is run. You probably have this sheet active when you run the debugger and that is why it is working.

[smokebreak]

Leith, thanks for your response. However, changing the code to

Please Login or Register  to view this content.

Does not remedy the problem.

[smokebreak]

After some additional researching, here is what I found (in case someone else is looking for this one day).

ActiveSheet.RefreshAll was refreshing my linked table in the background, which the protected sheet didn't like.

Below is the code that works:

Please Login or Register  to view this content.

[Leith Ross]

Hello smokebreak,

Thanks for sharing what you found. This is classic example of why you should post all of your code or the workbook. The refresh was a critical piece that got let out.