hide column on double clicking certain cell

[bta]

Hi Experts,
I want to hide and unhide column AI by double clicking on a certain cell, let's say S25. Can this be done?
Greetings, Bengtar

[DonkeyOte]

bta, yes you can use the Before DoubleClick event on the sheet in question.

In native XL right click on the tab you wish the code to fire against, select View Code and insert the below into the resulting window:

Please Login or Register  to view this content.

[royUK]

Try this

Please Login or Register  to view this content.

[mudraker]

Another slight differentr version

'These instructions pre typed & are worded to cater for the novice programmer
'To install macro to correct location

'Copy this macro
'GoTo Excel
'Select sheet this is to appy to
'Right Click on Sheet Name Tab > select View Code
'Past macro into the Worksheet Module displayed

Please Login or Register  to view this content.

[DonkeyOte]

Note, as per my example, if the double click action on S25 is purely to toggle column visibility be sure to use Cancel = True on the event itself
(else you will be in Edit Mode on the Target).

[mudraker]

DonkeyOte

thanks for pointing that out I forgot about that little trap

[bta]

Could this also be possible with a single click?

[royUK]

There is no single click event, you could use the BeforeRightClck event

[bta]

Thank you all!