Analysis is finished! You’ve got all your pivot tables in place, now all you need to do is prep your spreadsheet for your audience – i.e. people should not be able to view your calculation tabs and edit your analysis tabs 🙂
Easy, peasy! Just hide and protect!
Yet, if you have a couple of analysis tabs (trends, portfolio, per segment, MMixTrigols) and a couple of calculation tabs (Industry Dashboard, Firm R numbers, Products-TRIGOLS, Products-SQUAZOLS, charting), it could take a good 15 minutes doing the mind-numbing tasks of hiding sheets, pressing the “Protect Sheet” button and entering a password.
Further still, whenever you’d like to make a change, you’d have to go through the whole process again…
Yes, pretty annoying, right?
But no worries, if you use the short VBA snippet below, you’ll be done in no time 😉
Happy VBA coding!