Hi all,
I have a large spreadsheet with 24 sheets of information, two for each month throuout the year. The first twelve (jan-dec) are to be used and veiwed be the administrator only and so I need to put a password on these sheet that stops all other users from seeing the information.
The first 12 sheets control the second 12 sheets via VLOOKUP and HLOOKUP but only display non sensitive information. So basicly anybody can view the non sensitive data sheets but only the administrator can view the sheets with sensitive data.
I have viewed the Microsoft help but that only shows sheet protection which stops people from making changes, I need sheet protection which stops users from actually viewing the sheet.
Could anybody provide me with a VB/VBA script that will enable this.
Any help will be greatly appreciated.
I have a large spreadsheet with 24 sheets of information, two for each month throuout the year. The first twelve (jan-dec) are to be used and veiwed be the administrator only and so I need to put a password on these sheet that stops all other users from seeing the information.
The first 12 sheets control the second 12 sheets via VLOOKUP and HLOOKUP but only display non sensitive information. So basicly anybody can view the non sensitive data sheets but only the administrator can view the sheets with sensitive data.
I have viewed the Microsoft help but that only shows sheet protection which stops people from making changes, I need sheet protection which stops users from actually viewing the sheet.
Could anybody provide me with a VB/VBA script that will enable this.
Any help will be greatly appreciated.
