unhide worksheet

I wrote a spreadsheet for a chum some 3 years ago. Now it seems there is an anomaly (!) and I need to 'have a look' The workbook has 3 sheets one of which is hidden. I need help to make this sheet visible All sheets are unprotected The workbook is unprotected I have tried Right Click on a...

Hi I hope you can help me with below. In sheet2 cell B8 there's name of hidden sheet. Is there a vba I can use to unhide the sheet based on the value of this cell? when I use below it's working Worksheets("Template").Visible = True but I would like to refer to cell B8, which is variable...

Hi Everyone, The issue I am having is that the Worksheet_SelectionChange is not firing for me. I have a bunch of worksheets hidden in the file to decrease clutter, with a Navigation page visible - where clicking on the cell with the tile would unhide a corresponding sheet. For example cell B3...

I'm trying to create a macro that will unhide multiple worksheets between 2 specific worksheets. For example, my first tab is called "Start" and the last tab is called "Finish" and I want the macro to unhide all of the tabs found b/t "Start" and "Finish". Any help is greatly appreciated! Thanks!

My workbook is not protected. I have about 20 out of 45 worksheets that are hidden (25 worksheets visible at all times). When the workbook is closed, I unhide 6 of these worksheets so our servers can read the worksheets when the file is uploaded. When I try and unhide using...