Excel Razor Scabbard----VBA to hide the worksheet completely

The way to hide worksheets is to share with you today. In general, it is also known as a way to right-click on the worksheet you want to hide and select Hide. Operation is as follows

650) this.width=650; "style=" Float:none; "title=" 31.JPG "src=" http://s3.51cto.com/wyfs02/M02/6F/10/ Wkiom1wq7lfwgggdaacoygtoc_q859.jpg "alt=" Wkiom1wq7lfwgggdaacoygtoc_q859.jpg "/>

If I find Sheet2 again, I will be gone.

650) this.width=650; "style=" Float:none; "title=" 32.JPG "src=" http://s3.51cto.com/wyfs02/M00/6F/0D/ Wkiol1wq8bmty6rkaaczzarbk3s162.jpg "width=" 452 "height=" 257 "alt=" wkiol1wq8bmty6rkaaczzarbk3s162.jpg "/>

If it is displayed again, right-click on the Sheet tab and select Unhide

650) this.width=650; "style=" Float:none; "title=" 33.JPG "src=" http://s3.51cto.com/wyfs02/M00/6F/10/ Wkiom1wq7lijimekaaco5d1xods079.jpg "alt=" Wkiom1wq7lijimekaaco5d1xods079.jpg "/>

Select the worksheet that you want to hide before you can display it.

650) this.width=650; "style=" Float:none; "title=" 34.JPG "src=" http://s3.51cto.com/wyfs02/M00/6F/10/ Wkiom1wq7ljju30xaadouy1lxmo890.jpg "alt=" Wkiom1wq7ljju30xaadouy1lxmo890.jpg "/>

As above, we hide the work cannot be achieved such as hiding the data source, hiding the purpose of not wanting to let other people see the data is right.

Here's another way to hide a worksheet, which is to go to the VBA editor and manipulate the properties of the object sheet.

First, right-click the worksheet that you want to hide, and then tap View Code to enter the VBA editor

650) this.width=650; "style=" Float:none; "title=" 35.JPG "src=" http://s3.51cto.com/wyfs02/M01/6F/0D/ Wkiol1wq8bmr5jktaacjpqcq-b8797.jpg "alt=" Wkiol1wq8bmr5jktaacjpqcq-b8797.jpg "/>

Then select the object Sheet2 and select its Visible property as 2-xlsheetveryhidden

650) this.width=650; "title=" 39.JPG "src=" http://s3.51cto.com/wyfs02/M02/6F/0D/wKioL1WQ8bHipZs5AAIeW-oqaYU727.jpg "alt=" Wkiol1wq8bhipzs5aaiew-oqayu727.jpg "/>

As above, the Sheet2 is completely hidden, so that if other users want to display Sheet2 again, unhide the worksheet becomes grayed-out if the normal operation is done.

650) this.width=650; "style=" Float:none; "title=" 37.JPG "src=" http://s3.51cto.com/wyfs02/M01/6F/10/ Wkiom1wq7ljhxboxaadauaycylw979.jpg "alt=" Wkiom1wq7ljhxboxaadauaycylw979.jpg "/>

Of course, this method is limited to the ordinary user's hiding. It is meaningless if the other side knows the way. If you really want to protect your worksheet completely, there are other ways to do it.

The so-called however persuasive outsmart, all operations are relative.

Share it with friends in your circle. Thank you for supporting the original.

This article is from the "Guo Yong Technology blog" blog, make sure to keep this source http://guoyong.blog.51cto.com/408495/1669045

Excel Razor Scabbard----VBA to hide the worksheet completely