Code execution

[excelsean]

Yesterday was my first post. Thank you 'Brian in Maui' for your reply.

Today I'm inserting canned code into a worksheet module macro. When I drop it in an individual sheet, it works great. When I drop it in "This Workbook" the code does not function. If I want the code to function for every sheet, how can one do it?

Thanks!

Sean.

 

[Ram Chowdar Doss Azuph Al]

On 2002-09-14 12:21, stevebausch wrote:
Tom is correct; you can have every sheet covered with his technique.

If there would be an 'exception to the rule' worksheet, you could use my technique.

Steve

If there is an exception to the rule, I would suggest that the Workbook level event should still be used.
Just amend the code slightly to work for all sheets other than the exception