Derek has attended:
Excel Intermediate course
Hidden columns and passwords
This is long winded so I apologise in advance.
I run several month end spreadsheets which has only information that is only needed by me as the accountant, however I have to send the spreadsheets out to other countries, the question I would like to know is how do I hide a certain page on a spreadsheet ( Which may have my profit on and I donot want to disclose to other parties) or a TB analysis which again I donot want other parties to view.
I understand the principle of hiding the page, but when I send the spreadsheet with a hidden page, how can I password protect this page so others cannot view.
Currently I save as " new name" and send with hidden column, but would guess it wouldn't take someone very long to realise that a sheet has been hidden, I would also expect I can send my original work sheet to all parties and when sent, reverse the password on a certian page, so I can continue for the following month/quarter.
Hope this makes sense?
RE: Hidden columns and passwords
Hi Derek
Thanks for your question - no apology necessary, we are happy to help where we can.
What you could try doing is:
1. Hide the columns and/or rows which contain the information you do not want the other parties to see.
2. Then apply password protection to the sheet (Tools - Protection - Protect Sheet).
3. Then hide the sheet once the columns/rows have been hidden and password protected.
That way someone could still work out that there was a hidden sheet, and unhide it, but they would not be able to see the information you have hidden within that sheet unless they knew the password you had set.
I hope this helps to solve your problem - if not, reply and let me know and I'll see if I can get back to you with a more appropriate solution.
thanks
Amanda
RE: Hidden columns and passwords
If you use Excel xp or later, here's the option:
1. Press Alt-F11 to display the Visual Basic Editor
2. in the Project window, double-click Microsoft Excel sheet to hide.
3. Press F4 to display the Property box if not displayed
4. Set the sheet's Visible property to xlSheetVeryHidden.
To unhide the sheet, repeat these step, but set the Visible property to xlSheetVisible
