sh.visible

  1. L

    Hide Unhide Specific Sheets

    Hi, I created the below code a few months ago but just wondering how I could make it shorter? The premise of it is that you enter the admin password and it will hide 6 admin sheets using their codenames. This is then assigned to a button in my workbook and it will hide and unhide. Is there a...
  2. D

    code no longer work

    hi the following code always worked but know fails Sub SubTeste() Dim sh As Worksheet For Each sh In Worksheets sh.Visible = xlSheetVisible Next sh Worksheets("Sheet1").Visible = xlSheetVeryHidden End Sub the idea is when a file is open every sheet is shown if macros are enable it...
  3. L

    VBA If Multiple Sheets Are Visible Then Very Hidden Else Visible

    Hi, I've tried to come up with this code but it won't work - can anyone advice please? Trying to make a button that will hide and unhide the sheets below however need it to be very hidden.. I can make it work with normal hidden but this allows the user to unhide manually which I don't want to...

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