Checkbox validations

[Nikhil2803]

Hi Team, I am new to Excel VBA and macros. I am working on one request. There are two sheets in an excel sheet. under sheet 1, there are few checkboxes and there are few columns in sheet 2. The requirement is: if i check the checkbox in sheet 1, some x,y and z columns under sheet 2 should be disabled. Please help me how to achieve this. May be using Macros.

 

[Bosquedeguate]

Hi Team, I am new to Excel VBA and macros. I am working on one request. There are two sheets in an excel sheet. under sheet 1, there are few checkboxes and there are few columns in sheet 2. The requirement is: if i check the checkbox in sheet 1, some x,y and z columns under sheet 2 should be disabled. Please help me how to achieve this. May be using Macros.

What do you mean or intend when you say "disable" columns? Hide them? Lock and Protect the Sheet? Prevent entries in these columns without Locking the Sheet? Please clarify

 

[Nikhil2803]

What do you mean or intend when you say "disable" columns? Hide them? Lock and Protect the Sheet? Prevent entries in these columns without Locking the Sheet? Please clarify

Sorry for the confusion. I just need to hide the columns on the basic of checkbox

 

[Bosquedeguate]

Here is VBA code tied to the click event of a CheckBox on Sheet1
I selects (navigates to) Sheet2 and hides/unhides columns X,Y, & Z
You may not want it to jump from Sheet1 to Sheet2, but hide/unhide the columns regardless.
Please provide feedback.

Sub HideUnhideCol_Click()
'
' CheckBox26_Click Macro
'

'
    Sheets("Sheet2").Select
    ActiveWindow.ScrollColumn = 2
    Columns("X:Z").Select
    
    With Selection.EntireColumn
      .Hidden = Not (.Hidden)
    End With
End Sub

 

[Bosquedeguate]

Snapshot of the Checkbox on Sheet1 - it is linked to the macro code in the previous reply.

 

[Nikhil2803]

Here is VBA code tied to the click event of a CheckBox on Sheet1
I selects (navigates to) Sheet2 and hides/unhides columns X,Y, & Z
You may not want it to jump from Sheet1 to Sheet2, but hide/unhide the columns regardless.
Please provide feedback.

Sub HideUnhideCol_Click()
'
' CheckBox26_Click Macro
'

'
    Sheets("Sheet2").Select
    ActiveWindow.ScrollColumn = 2
    Columns("X:Z").Select
   
    With Selection.EntireColumn
      .Hidden = Not (.Hidden)
    End With
End Sub

Perfect. Thank you

 

[Bosquedeguate]

This easy to setup.
- record the macro
- add the checkbox
- link the macro to the checkbox
- edit the macro as needed

 

[Bosquedeguate]

If your problem/needs are resolved please flag your Post as "Solved". Muchas gracias!