I need some help cleaning up VBA and adding some new features if possible.
I don't have a lot of experience, so I've bodged different code together that I've found online.
I'm sure anyone who looks at my code will see that it's quite tragic.
Basically I've created a directory worksheet to control the remaining worksheets in my workbook.
In the directory I have some macros that can hide / show the other worksheets, and also rename them when certain cell values change.
I have very limited VBA experience, so the code I've used is really clunky and slow.
Would someone be able to have a look over it and recommend how to speed it up?
I've no idea where to start.
I'm also trying to include two more features in the "Directory" but don't know how.
1. I'd like to enable / disable auto calc for specific sheets, if a certain cell says "Yes".
2. I'd like to copy the contents of a template sheet to other sheets if a certain cell says "Yes".
It might sound weird, but it'd all make sense when you open the attached spreadsheet.