How to write the code for toggle button...stupid things

[nadirv8]

Hi All,

Having issues with a macro im trying to get working for a button. All it is: selecting multiple columns and hiding them. This is it (below) and VB is rejecting the range,... or any range for that matter.

Private Sub CommandButton1_Click()
    Sheets("Holland").Select
    Range("D:D,H:H,L:L,P:P,T:T,X:X,AB:AB,AF:AF,AJ:AJ,AN:AN,AR:AR,AV:AV").Select
    Range("AV1").Activate
    Selection.EntireColumn.Hidden = True
    Sheets("CONTROL").Select
    Range("D1").Select
End Sub

Anyone got ideas of why its not working on the button?

Thankyou very very much!

 

[DominicB]

Good morning nadirv8

There is nothing wrong with the code per se. What sheet is the button placed on? You can have problems running code behind a button on Sheet A if it is selecting a range on Sheet B.

As a workaround you could put the code in a standard module and call it from your command button code.

HTH

DominicB

 

[Joe4]

Question continued here:
http://www.mrexcel.com/board2/viewtopic.php?t=233103

Please do not start a new thread in the future, simply continue on in the original.