Quickest way to get code onto every sheet?

**kirsty** · 12-17-2010, 07:36 PM

I have the following macro in one worksheet of a workbook and I need it to run on every worksheet. I'm wondering if there is a way to revise the code and put it into the Workbook object and have it run on all sheets or if there is a macro I can use?

Please Login or Register  to view this content.

Thank you!

**protonLeah** · 12-17-2010, 07:58 PM

You might try the Workbook_SheetSelectionChange
in the ThisWorkbook module..

**kirsty** · 12-17-2010, 08:30 PM

Thank you for the suggestion. I tried it, and I received this error message:

Compile error:

Procedure declaration does not match description of event or procedure having the same name.

My code is now in the Workbook object and looks like:

Please Login or Register  to view this content.

**Marcol** · 12-17-2010, 08:40 PM

The code in the workbook module should be

Please Login or Register  to view this content.

Where did you get the argument "ByVal Target As Excel.Range" from?

Hope this helps

**kirsty** · 12-17-2010, 08:42 PM

Thank you Marcol! Works like a charm.

**Marcol** · 12-17-2010, 08:50 PM

Happy to help.

When using Sheet/Workbook Events, don't change the built in arguements.

I am still interested how you arrived at "ByVal Target As Excel.Range" was it from some other application?