![]() ![]() How to make Excel worksheets very hiddenĪs already mentioned, the only way to make a sheet very hidden is by using the Visual Basic Editor. those containing sensitive information or intermediate formulas), apply this higher level of sheet hiding and make them very hidden. So, if you want to make some of your worksheets much more difficult to unhide by others (e.g. While anyone can toggle between TRUE (visible) and FALSE (hidden) by using Excel's Unhide or Hide commands, the xlVeryHidden value can only be set from within the Visual Basic Editor.įrom the user's perspective, what is the difference between hidden and very hidden sheets? It is simply this: a very hidden sheet cannot be made visible via the Excel user interface, the only way to unhide it is with VBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |