hiding sheets

Hi, I'm trying to make a spreasheet where if there is a "0" on the first sheet, it will hide a corresponding sheet. For example, if B2 has a "0", then Sheet2 will be hidden and same thing until B18 and Sheet18. I have this code right now that works for one sheet: Private Sub...

Hey, I need a code in VBA. So, when I navigate between two sheets in excel, the need the latter one to be hidden and not displayed Can anyone help?

Hi , The login form should have access to multiple admin and sub user, Where the admin can give access only to few sheets to there sub user for editing and other sheet has to be hidden. I require VBA code.

I have some code that hides and unhides a worksheet in excel. The table below is an example of my data. I have yes and no option buttons that open and close other worksheets depending on the answer. Yes would open a worksheet and no would close it. <tbody> Geotechnical yes no Investigations...

I also am trying to force users to enable macros, but the VBA code that I found searching Google conflicts with my cases for each worksheet. I thought a better alternative might be initially hiding (using VeryHidden) all the worksheets except my menu and then forcing the user to enter the...

Hi all, This will be a simple fix for you clever VBA people out there. The highlighted code below basically means that if you select any option from a drop down list (E4 is a drop down list) other than Select Entity - the first option, then the Other and BL_PS worksheets will be opened...

Hi, Have created a combo-box with a list of values. Depending on value in linked cell I then want to hide and unhide certain sheets. I have tried to create an If command with Array for lists of sheets with ElseIf. Works fine for hiding sheets, but get 'Run-time error '1004': Unable to set...