How to Hide the Worksheet ?

| More

Making a worksheet very hidden

You can use Excel’s Format, Sheet, Hide to hide an entire worksheet. But unless you password-protect the workbook structure, anyone can select Format, Sheet, Unhide to see the hidden sheet.

There is another option:

  1. Press Alt-F11 to display the Visual Basic Editor

  2. in the Project window, double-click Microsoft Excel Objects and select the sheet to hide.

  3. Press F4 to display the Property box

  4. Set the sheet’s Visible property to xlSheetVeryHidden.

To unhide the sheet, repeat these step, but set the Visible property to xlSheetVisible.

Blog Widget by LinkWithin

Related posts:

  1. Copy Page Setup Settings to other sheets
  2. Protecting cells, sheets, workbooks, and files
  3. 20+ Microsoft Excel Printing Tips
  4. Remove and Hide Facebook Ads easily.
  5. Resize Excel’s Sheet Tabs
  6. Moving Between Precedent and Dependent Cells
  7. Create, Edit, Annotate, Manage and Display XPS, XAML, RTF Text Document with Danet Studio
  8. Useful Tips in Excel
  9. Remove Password from Excel files – Excel Add-in
  10. Adding Drop-Down List in Excel

Get Freeware updates just like this one in your email inbox every day - for free! Just enter your email address below:

 

blog comments powered by Disqus

Binary Head | About us |  Copyright Policy |  Privacy Policy |  Disclaimer |  Subscribe us |  Advertise |  Contact us |  RSS Feed |  Sitemap