Combine two macros and run them on double clicking a cell

[dittotharappel]

I have two pieces of code. The first one puts a tick mark in the cell when you double click it. The second one hides column B of another sheet if the value in cell A1 of Sheet1 is "a". I want to combine these two codes so that when I double click cell A1 of sheet1 it puts a tick mark in the cell and hides column B of Sheet2 and clears the contents of range B2:B50 of Sheet2. Please help me.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Just before the second End If in the Before_DoubleClick procedure add the instruction

Please Login or Register  to view this content.

HTH

[shg]

Maybe like this:

Please Login or Register  to view this content.

[dittotharappel]

Thanks Richard and shg.
Both the code pieces work fine. Thanks a lot for quick help.

[shg]

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes