Macro to Highlight ActiveRow w/ DoubleClick

Hi,

I am trying to use the code below to highlight the active row with a double-click but it's been a dud. The user is double-clicking on a GL Account Number in column A and I would like that particular row (A:W) to format to a style I defined as "Highlight".

Any advice on my mistake is appreciated.

Please Login or Register  to view this content.

I don't think it matters, but I am successfully running this code on the same worksheet. The user is double-clicking a GL Account Number and it is being pasted into cell A1, which ultimately fuels some index formulas.

Please Login or Register  to view this content.

Yes I do, but I am open to hard-coding the format rather than referencing a style. I just want it to bold and highlight in an off yellow.

Does this help?

Please Login or Register  to view this content.

It is still not working. It is not failing with a bug, but the macro is not changing the sheet.

Where did you get the 2 from?

Please Login or Register  to view this content.

I added it in there myself because the other macro running on the same sheet has the same generic name.

I don't think you can modify an event code like that take the 2 out and see if it works. Your original might work as well.

That fixed it! Great catch, but it will not allow me to run two macros with the same name, any thoughts on how I can execute both macros on the same worksheet?

Also, is it possible to have the highlight removed upon double-clicking the next selection? I can not clear all highlights because I have some rows highlighted within that range for other purposes, but I only want one row highlighted in yellow at any given time.

Thank you much for all the help!

Perfect! Thank you. I see that I can double click the GL Acct Number a second time and it will clear the highlight.

Thanks!

You're welcome. Glad to help out and thanks for the feedback.

@ Winon: Thanks for the pointers, I should know that by now. And do it as a matter of habit. But I'll try to keep it in mind.