auto open code

[bob_br]

I have a spreadsheet with numerous identically formatted worksheets. I want to have the following macro run on the appropriate worksheet whenever cells O28, P28, or Q28 are changed on that worksheet. The code below obviosuly only works on Sheet1 however I'd like to edit the SUb auto_open code to run on any worksheet. How can I do that?

Please Login or Register  to view this content.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time.

[royUK]

Does the posted code actually work?

[bob_br]

Yes, but maybe I can simplify my question. What this code does is call the macro when those particular cells are changed, O28, P28, or Q28. However in the auto_open function, I am only referencing Sheet1. Somehow I would like the macro to be called when those cells are changed on ANY worksheet.

I imagine this would just require a change in the auto_open function though I can't figure it out.

[shg]

Maybe like this:

In ThisWorkbook:

Please Login or Register  to view this content.

In a code module:

Please Login or Register  to view this content.