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 of searching and I'm struggling to find anything that comes close to achieving this.
I have a worksheet named "Directory" and all of my worksheets are listed from A2:A39.
Column D is used to show worksheets with a blank cell for "Yes"
Column E is for enabling Auto calc for the respective worksheet with "Yes" in the column cell.
I'm hoping that I can hide/unhide by typing "Yes" in col D and similarly enable/disable the auto calc on the sheets by typing "Yes" in col E.
Any help would be greatly appreciated.
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 of searching and I'm struggling to find anything that comes close to achieving this.
I have a worksheet named "Directory" and all of my worksheets are listed from A2:A39.
Column D is used to show worksheets with a blank cell for "Yes"
Column E is for enabling Auto calc for the respective worksheet with "Yes" in the column cell.
I'm hoping that I can hide/unhide by typing "Yes" in col D and similarly enable/disable the auto calc on the sheets by typing "Yes" in col E.
Any help would be greatly appreciated.