.entirecolumn.hidden

  1. G

    Hiding columns when other columns become visible

    I have written some code to make some columns visible based on a click of a button. I'd like to make it so when these columns appear (L & M) three other columns are hidden (I, J, and K). Any suggestions would be welcome. Thanks! Sub Hide() Sheets("Increase Program Workbook").Unprotect...
    • Godot60
    • Thread
    • .entirecolumn.hidden columns end password=password true
    • Replies: 7
    • Forum: Excel Questions
  2. S

    Toggle Button Color Change When Depressed

    I have about 30 buttons that I am trying to add a line of code that will change the color of the button when pressed and depressed. Any ideas? Private Sub ToggleButtonAHAJ_Click() With Columns("AH:AJ") If .EntireColumn.Hidden = True Then .EntireColumn.Hidden = False Else...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top