Select Change VBA unhiding hidden column

[The_Steward]

I am using select change to change column width and remove text but when I click a different cell it unhides my hidden column that I put my hyperlinks in. Why is this happening?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address = "$G$12" Then
Target.Columns.ColumnWidth = 50
Else
Columns.ColumnWidth = 15
End If

If Target.Count > 1 Then Exit Sub
If Target.Address = "$G$12" Then
Target.Cells.Value = ""
End If

 

[Peter_SSs]

Why is this happening?

Columns.ColumnWidth = 15

The above is setting all columns to width 15.
Did you mean this?

Target.Columns.ColumnWidth = 15

 

[The_Steward]

Columns.ColumnWidth = 15

The above is setting all columns to width 15.
Did you mean this?

Target.Columns.ColumnWidth = 15

Thankyou! Silly miss.

 

[Peter_SSs]

Thankyou! Silly miss.

You're welcome. Never mind, it happens and the forum provides extra pairs of eyes which usually helps.

 

[The_Steward]

Hello Peter I now have the issue on this sheet of the hidden row becoming unhidden when I click one of the hyperlinks on the sheet. I have several other sheets with the same hyperlink and VBA attached to these links but the sheet in question above is the only one doing and I can't figure out why, any suggestions?

 

[Peter_SSs]

.. the hidden row becoming unhidden ...

Nothing about hidden rows before? Details?

.... when I click one of the hyperlinks on the sheet....

Nothing about hyperlinks before? Details?

What does this have to do with G12?

 

[The_Steward]

Nothing about hidden rows before? Details?


Nothing about hyperlinks before? Details?

What does this have to do with G12?

Sorry Hidden Column, Column A. I have Hyperlinks in Columns B and C. From doing some testing I have realised this only occurs when it is an unprotected sheet. So not realistically not an issue for my users thankfully. Still not sure why it does this though. Has nothing do with G12 as far as I am aware.

Please see image for further details.

 

[Peter_SSs]

Has nothing do with G12 as far as I am aware.

The code we started with in post 1 was all about G12 & there has been nothing since to say otherwise.

So not realistically not an issue for my users thankfully.

A lot of "not"s there. Does that mean you are right to go?


Edit: And there was mention of hyperlinks earlier - my mistake, sorry.
But they were not mentioned/used in the code.

 

[The_Steward]

Yes all good to go thankyou! Back then it was all about G12 but thanks to your keen eye that was sorted. Sorry for the confusion.

 

[Peter_SSs]

Yes all good to go

OK, great.