Hmmm.... I could have sworn I did this yesterday! Anyways I have a 2 part request.
1. I need a macro that will hide specific tabs in a workbook. I found the macro that will hide and restore all tabs but I only want to hide tabs after the "Monitoring Units Worksheet" leaving the 1st 3 tabs open. On the example I have attached I currently have in place the Hide all and restore all tabs macro. Button 2 will restore all tabs.
2. Considering the option of password protecting the "hidden" tabs. ie can't open without a password.
Thanks for all your help. I do have 1 final request re: this and that is since I am a total newbie with VBA (macros) if you could be detailed in your instructions I would GREATLY appreciate it!
You think VBA counts as a foriegn language for College? (jk :D )
Bookmarks