Tip Hide professional Excel spreadsheets
In the office work, if you need to hide a worksheet in an Excel document without wanting others to use the Format> Sheet command> Unhide to view the spreadsheet, the usual way is to use the Format> Sheet command> Hide to hide it. spreadsheets (if not protected by a password), then only people who are not expert will also c & o
In the office work, if you need to hide a worksheet in an Excel document without wanting others to use the Format> Sheet command> Unhide to view the spreadsheet, the usual way is to use the Format> Sheet command> Hide to hide it. spreadsheets (if not protected by a password), then just a non-expert can use the Format> Sheet> UnHide command to make it appear.
But when you apply this tip, your spreadsheet will be much safer and this is also a new "way" for readers to read and gain more choices in their work.
The steps are as follows: In the spreadsheet that needs to be secured, press ALT + F11 to open the Microsoft Visual Basic window. In the Project - VBA Project window, double-click the VBA Project , double-click Microsoft Excel Objects to open the worksheet in the document then select the worksheet you want to hide -> then press F4 . In the Visible option, click the triangle mark to select 2-xlSheetVeryHidden , finally close this Microsoft Visual Basic and see how the result is
When you want the spreadsheet to appear again, you just need to repeat the above actions and choose - 1-xlSheetVisible is okay.
Into rotation
You should read it
- How to Make a Shared Spreadsheet
- How to Make a Spreadsheet
- How to Make a Spreadsheet in Excel
- How to Open an MPP File on PC or Mac
- How to Make a Finance Spreadsheet
- How to Create an Excel Spreadsheet Without Excel
- How to Remove a Macro in Excel
- How to Learn Spreadsheet Basics with OpenOffice Calc
- Microsoft Project Spark: Tool to help anyone can make games
- Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheets
- How to Make a Google Spreadsheet
- Toshiba will be the main supplier for Project Ara
Maybe you are interested
How to turn off Update Link notification in Excel - File content from many different sources Create Autotext in Word 2007, edit documents faster How to quickly fix text simplification errors in Word when copying from the internet Alignment in Word 2010, beautiful alignment of Word 2010 documents Excel 2016 - Lesson 8: How to format numbers in Excel (Number Formats) How to master numerical data in Google Sheets with the AVERAGE function