Apply code to entire workbook.

[kgall89]

Hello all. I have found a Macro online to help me solve one of my issues, but this macro is coded to only work on one sheet and I am wondering how to change it to work for the entire workbook. The code is as follows:

I am looking to double click a cell in either Column C or G and have it copied to Column I in the same row. As of now this works but only on my sheet titled Week 4.

Any help is appreciated!

[XLent]

PLease add code tags.

Check out ThisWorkbook... the same events are available but with Workbook level scope, e.g.:

Please Login or Register  to view this content.

Note: additional Sh Object, this defines the Sheet triggering the event.

[kgall89]

I apologize XLent, I am extremely new to excel and coding, I believe I edited the question to include tags now? I was able to get this code by googling my issue and finding a similar issue, then changing what I knew to fit my workbook.

Thank you for the response and help!

[kgall89]

When I add in the Sh As Object, and try to use the double click I am shown this error:

Compile error:

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

[XLent]

To clarify, the code should reside in ThisWorkbook object, not the Sheet object where you previous event would have been placed.

edit: added below link for ease of reference:

https://www.myonlinetraininghub.com/...ents-excel-vba

[kgall89]

Okay, I did not have that in the correct object. I moved/edited and this works!

Thank you very much for your time and patience, XLent