Specifying a sheet & range in ThisWorkbook module

[vwhite]

Hi All,

I'm sure this is really simple but I just can't figure out what's wrong
I have a small piece of code in the 'ThisWorkbook' module that changes a specific cell from FALSE/TRUE whenever the workbook is saved

Please Login or Register  to view this content.

Unfortunately this code executes on whichever sheet I am on at the time
How can I specify which sheet this should run on?

I've tried the following

Please Login or Register  to view this content.

But this gives "Runtime error 1004 - select method of range class failed"

And also

Please Login or Register  to view this content.

But this still executes on the active sheet rather than sheet4 ("INV & CRN")

Any help would be appreciated
Kind regards
V

[AlphaFrog]

Please Login or Register  to view this content.

[vwhite]

That works perfectly! Thank you so much