hide / unhide worksheets

Hi, Is there a way to make sure that only i can unhide one of the worksheets in a workbook using a password? I have two worksheets. One of them is hidden, but i'd like to lock it with the password. I wouldn't like to have any password prompts when other users open the workbook, but rather the...

Hello, my name is Ryan, I've been using different codes to accomplish hiding rows on my sheet, which work but as I go along, and the cell changes it does not unhide rows like I thought it would. I have a safety meeting data on a spreadsheet, one sheet (Safety Meeting 101) is an interactive...

Hello Gurus, I have a massive excel file with so many tab sheets. Some may be blank sheets so can you share some VBA code for this one? Appreciate if you have the code to hide and unhide sheets that are blank. Thank you!

It appears that you cant have this library reference in code on Office 2013 standard. However my file is not using powerpivot or power query in any way. Still when I go to run the below code it errors out, anyone any ideas of a way around this? All i want to do is hide and unhide certain tabs...

Hey guys, I have an usual vba question to ask. Is it possible to create a worksheet that acts as a directory for all the worksheets in workbook? I want to be able to use this directory to show/hide certain worksheets & also enable/disable autocalc for certain worksheets as well. I've done a lot...

Hi All, This forum has been so helpful as I am trying to learn about VBA and macros. I do have a question. I have a workbook with a ton of worksheets. The main sheet is "2019". Then each month has 3 different sheets: "January Late Cancel", "January No Show", "January Early Departures"...