unhide sheets

Hello, Am new here and I don't know if I should create a new thread but my question is related to dynamic hyperlinks. Anyways, I created a dynamic hyperlink that can jump to desired sheet based on the sheet name. It works fine. The issue is that the dynamic hyperlink won't work if sheet are...

Microsoft is steadily improving Office 365, but a thorn in our collective side for decades has been the constraint that we can only unhide one worksheet at a time from within the Excel interface. Yes, we can use VBA to loop through and unhide all sheets, but this is a basic usability feature...

Hi I'm looking to see if there is a way to unhide sheets based on a cell value imputted on a main sheet, which then finds the cell value within other sheets that are hidden. So I don't want to unhide the sheets based on their sheet tab name, but to find the cell value within the sheets to...

I am trying to create a button on the ribbon that will allow the user to hide only sheets not selected. For example, if I have workbook with [Sheet1, Sheet2, Sheet3, Sheet4] and the user has selected [Sheet1 & Sheet3] then [Sheet2 & Sheet4] would hide. I have the VBA to hide all (except the...

Good Morning all. Hope you are all well. Hopefully someone on here can help me with an issue i'm having in excel and it's this:- I have a workbook with around 150 sheets in. this workbook is a generic workbook that is used for many projects . . . however . . . not all sheets need to be...

I am writing a macro that checks the value of specific cells on a sheet titled 1-SUMMARY and unhides specific sheets if the value of the cell is greater than $0.00.