I have an excel spread sheet with 6 sheets. sheet2(home) is home page navigation sheet where i have put in a combo button which prompts for a password. I am very new to vba and really struggling and was hoping that maybe someone might be able to help me.
problem 1: I want sheet2(home) to always be the first sheet to open.
problem 2: When the correct password lets say "password" gets entered I want the macro to automatically unhide and unprotect all columns in all worksheets that have been protected with the password "password3"
I also want a macro called 'reprotect' to lock and then hide and password protect columns I:J on sheet 3 and columns m:n on sheet 4 etc all with password "password3"
problem 1: I want sheet2(home) to always be the first sheet to open.
problem 2: When the correct password lets say "password" gets entered I want the macro to automatically unhide and unprotect all columns in all worksheets that have been protected with the password "password3"
I also want a macro called 'reprotect' to lock and then hide and password protect columns I:J on sheet 3 and columns m:n on sheet 4 etc all with password "password3"