![]() Indeed I don’t even need to unhide the worksheet to get the data on it.ĭid you notice that the name of the hidden worksheet was disclosed in the VB Editor? That’s the window you saw after clicking “View Code” in the above screencast.įrom there, I know that the Hidden Sheet is called “ Secret“. Here’s a simple trick to look into the data on the hidden sheet. YES! BUT… ARE YOU SURE NO ONE CAN SEE THE DATA ON IT? Now you are pretty sure that no one can unhide the worksheet, without the password. Since you are also a careful person, you test to make sure no one can unhide the worksheet unless one knows the password to unprotect workbook: As you know Excel well, you further Protect Workbook, with password set, in order to avoid user from unhiding the worksheet. ![]() ![]() However there is a worksheet with sensitive data that you don’t want them to see. Suppose you are going to share an Excel workbook to your colleagues. This post is inspired by the previous post Excel Humor #9 – You do not see me Situation ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |