I was able to find the code, I have updated the coding below. Feel free to educate me if there are better ways of accomplishing these needs.
I will say I am unable to add in coding to unhide all columns in the Unprotect macro because users without the password are able to run the macro, which will not unprotect all worksheets, but will unhide all columns (due to UserInterface = True), which defeats the entire purpose of this excercise.
Upon opening workbook, enable outline, allow filtering, hid columns, and collapse all grouping
Hide columns, collapse all grouping, protect all worksheets
Unprotect all worksheets, collapse all grouping, NEED: Unhide all columns ONLY WITH PASSWORD
Bookmarks