• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hide data of a worksheet and restrict user from entering a particular sheet

Umesh Chahar

Umesh Chahar

Member
Hi,
I have a dashboard in which there are 5 sheets, out of which one is Home page and the rest four sheets have data, the name of all four sheets is written on the home page , when i click on the name of a particular sheet a macro runs which ask for a password and i need to enter password to enter that sheet.
Now what i want even though i have entered the password of that sheet the data inside the sheet remains hidden until i run an another macro with a help of button provided in that particular sheet to unhide and unprotect the data. the data inside the sheets get hidden as i came out of the sheet to the home page.
One more thing i have done i have remove the sheet tabs but as soon as someone add it he\she can easily enter those sheets without entering passwords .so i also want to restrict this that even though someone added it but without providing passwords he\she cannot view the data .
i am attaching a sample sheet.
The password to enter into sheet is "123"
 

Attachments

I think you may be getting overly complex here, on something that can't be made that secure. Why the need for two macros to view the data? If you just want to stop them from editing the data, you can use sheet protection. If they can't view the data, then what's the point of the password?

Finally, note that ANY form of protection you try to setup in this way could be overcome by someone who knows their keyboard shortcuts (Ctrl+PgUp/PgDown to change worksheets), or creating a new workbook with formulas pointing at original workbook:
='[Sample Dashboard]Sheet2'!A1

So, that said, you need to evaluate how secure/sensitive is this information really, and where do you want the passwords? If you need the most secure, you could make it so you have to input a password to even open the file.
 
It probably is, but you didn't answer my questions:
Why the need for two macros to view the data? If you just want to stop them from editing the data, you can use sheet protection. If they can't view the data, then what's the point of the password?
Click to expand...
 
You must log in or register to reply here.
Back
Top