Macro VBA hide/unhide with veryHidden option and VBA password

[alexbw]

Hi to all,

after spending a lot of time and that i am not a macro expert i thought to ask here for help

To keep it sort the problem is the following

Excel workbook with 10 sheets

Sheet1 is for sales team that fill out data in some areas ( the sheet is sheetprotect ) , no worries about this sheet , i am ok.
Sheet2 same as Sheet1
Sheet3 until Sheet9 is filled with reports-charts etc for sales directors that take data from Sheet1 and Sheet2 , need to be hidden from sales team , but sales directors need to see.
Sheet10 , filled with cost and data that only top management need to see .

My thinking and top management agreed is to structure the file like below :

In sheet1 create 2 buttons assigned with macros
First button when clicked to unhide from sheet3 to sheet9 (sheets for sales directors)
Second button when clicked to unhide sheet10 (sheet for top management )

Both of them need to prompt with message to put a password before show the relevant sheets.

The second button need make veryhidden sheet10 so nobody can see that sheet10 exist.

And last , need another macro that make the opposite , hidden the Sheet10(verryhidden) and sheets from 3-9 and save the file ( i will put a button in sheet10 labeled "save and hide Sheets" ) ,
and same for sheets from 3-9 , in each sheet i will put button that save and hide all sheets 3-9 and save the file.

I already know that passwords will be hardwritten in code , no problem about that.

PS. need also that VBA project password protection , so no one can see the passwords

Thanks in advance for any help

 

[alexbw]

PS. need also that VBA project password protection , so no one can see the passwords, i am writing this because i dont know if needed to be inserted in the code also , if not its ok , i wll lock the vba