OfficeHelp - Office Tutorials & Software Solutions
Search:
 
Advanced Search

 
Get FREE PC TIPS every month:

More Information Here

Most Popular

What's available for:
Calendars
Privacy & Security
Excel
Outlook
Word
PowerPoint
Internet Explorer
Others


Get all OfficeHelp.Biz CALENDARS at once!

Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?


Other Contents
Design Chart Templates for Microsoft® Excel®
Automatically update hundreds of PowerPoint slides from Excel in minutes
Quickly and easily generate your own Org Charts in Excel
Easily make your own home and office calendars for Microsoft® Excel®!
Calendar Templates with Holidays (USA / UK / Australia / Canada) for Excel
Make stylish Planner Calendars - CUSTOM Version
Calendar Templates 2007 with Holidays for Excel
Make stylish Planner Calendars - ADVANCED Version
All TEMPLATES at once!
Make stylish Planner Calendars
Make stylish Planner Calendars - BASIC Version
Calendar Plan - Year Planner Template
How long the wait?

How to Buy
How safe it is to buy
Privacy Policy
Contact Us

RSS Feed OfficeHelp.Biz RSS Feed
Home Calendars Bundles Macros PC Tips Templates Newsletter Contact Us

Specializing in Advanced Spreadsheet & Office Macro Solutions.


Content Type Application Author Price
PC Tip Microsoft Excel OfficeHelp Free

SUPERHIDE Microsoft® Excel sheets - Version 1.00

Tested on Microsoft Excel Versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 97


 

Hiding Excel sheets is useful: you may want to remove complex contents users shouldn’t change, like lookup tables, or just want to protect your intellectual property and deny end-users the view of data that, being necessary for calculation, you don’t want disclosed. Anyone knows how to regularly hide Excel sheets – meaning anyone knows how to UNHIDE them. What if you could hide Excel sheets so well that it would take a hacker to unhide it?


Hiding Excel sheets is very useful to protect content, either for privacy/security reasons or for pure precaution - avoiding users messing, even involuntary, with complex data like lookup tables. But if you really want to protect the hidden content, you need to prevent users from unhiding it.

Regularly hidding/unhidding excel sheets - Using the trick EVERYBODY knows

There is a regular way to hide Excel sheets. It is very simple but the problem with it is that almost everyone knows how to unhide them - It is also easy. And, if they don't know, all they need to do is to search Excel help for "unhide sheet". To hide a Sheet, all you need to do is:

1) Select the Sheet you want to hide (Sheet2):

Select sheet to hide

2) Select Sheets on the Format menu and click Hide:

Hide it from the Format menu

3) The selected Sheet (Sheet2) is hidden:

The sheet is hidden

But anyone can unhide it again:

1) Select Sheets on the Format menu and click Unhide:

Unhide it from the Format menu

2) Select the sheet to unhide (Sheet2) from the list on the dialog box, then press OK:

Select the hidden sheet to unhidde

3) The selected Sheet (Sheet2) is unhidden:

The sheet is unhidden

New Privacy Level 1 - Using the trick nobody knows

There is, however, a trick that almost nobody knows because it demands utilization of an Excel feature most people don't know how to use, even if they know it exists - The Macro editor. To use it to hide an Excel sheet, you need to do this:

1) Open the Macro editor pressing the keys ALT + F11:

Open the Macro Editor

2) Select the sheet you want to hide (picture: Sheet2):

Select sheet to hide

3) Set the visible property to 2 - xlSheetVeryHidden. Don't set the property to 0 - xlSheetHidden, as it will be the same as hiding it from the Format menu!

Set the visible property

4) Save the changes. The sheet is no longer visible:

The sheet is hidden

New Privacy Level 2 - Password protecting the trick nobody knows

Level 1 privacy will work for most people because they will not know how to unhide the sheet. They will try the traditional way but nothing will appear on the unhide box so they will be lost. But if they search for help, on the web as a instance, they may find how to unhide it. In fact, they may find this very article on a search engine!

There is a solution for this - Set a password for the macro editor. users will be prompted for the password before they can access the sheet properties, so they cannot change them without either knowing the password or braking it - an hacker, not user, task.

To set a password for the macro editor, do this:

1) On the Macro editor, select VBAProject Properties from the Tools menu:

Open the Macro Editor

2) Select Protection on the dialog box and activate the "Lock Project for Viewing" box. Enter (twice) the chosen password. Press OK and save the file:

Select sheet to hide

 

Unhidden it again

Is there any way of unhidden the sheet after this? Of course, doing this:

  • Level 1 - Enter the Macro editor and change the visible property again for the default status -1 - xlSheetVisible. Save it again and the sheet will be visible.

  • Level 2 - Enter the Macro Editor, insert the password and change the visible property again for the default status -1 - xlSheetVisible. Save it again and the sheet will be visible!

It is also possible to delete the macro editor password:

  • Uncheck the "Lock Project for Viewing" box;
  • Enter a blank password replacing the original one (repeat Level 2 steps with a blank password).

Can I know more about this subject ?

Check our FREE PC Tips and Tutorials. They will be regularly published. Better still, subscribe our Email Newsletter. You will be informed when contents updates are made and automatically granted participation on any future promotion.

Get FREE PC TIPS every month:

 


SUPERHIDE Microsoft® Excel sheets - Version 1.00

Tested on Microsoft Excel Versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 97


Back
Other Contents  

00052- Design Chart Templates for Microsoft® Excel® Microsoft Excel Templates
The easiest way to create design charts. Check the samples, enter your own data and watch as your charts update. Multiple different charts from the same data, with many automatic calculations made for you. No code, macros, formulas or other complicated stuff. Just fill in YOUR data and watch the charts update automatically.
 
00054- Automatic Copy/Paste for Microsoft PowerPoint® Microsoft Excel Macro
Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.
 
00051- Organization Chart Maker for Microsoft® Excel® Microsoft Excel Macro
Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts.
 
00037- Traditional Calendars for Excel Microsoft Excel Macro
Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft® Excel®. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Microsoft ® Outlook®.
 
00047- Calendar Templates 2014 with Holidays (USA / UK / Australia / Canada) for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for Microsoft® Excel®. Includes versions with Holidays for the USA, UK, Australia and Canada.
 
00044- Custom GANTT Charts for Microsoft® Excel® Microsoft Excel Macro
Generate CUSTOM Project style calendar plans with the EXCLUSIVE option to customize our COPYRIGHT messages to create YOUR own REBRANDED Edition. Includes all ADVANCED Edition features plus the REBRANDING option. Distribute CORPORATE versions to your staff.
 
00027- Get all OfficeHelp.Biz CALENDARS at once! Microsoft Excel Bundles
Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00046- Calendar Templates 2007 with Holidays for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for 2007 in Excel. Include USA Holidays.
 
00002- Calendar Plan Generator - ADVANCED Edition Microsoft Excel Macro
Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like its name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel® file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.
 
00040- Get all OfficeHelp.Biz TEMPLATES at once! Microsoft Excel Bundles
Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00036- Calendar Plan Generator - Source Code Edition Microsoft Excel Macro
Generate Project style calendar plans (weekly only), just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. SOURCE CODE available for changes for VBA Macro developers.
 
00043- Calendar Plan Generator - BASIC Edition Microsoft Excel Macro
Easily generate Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. The SIMPLEST edition, just ONE button to use!
 
00028- Calendar Plan - Year Planner Template Microsoft Excel Templates
Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.
 
00001- Queue Servicing Calculator Microsoft Excel Macro
Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.
 

Privacy Policy How to Buy How safe is it to Buy? RSS Feed Contact Us

(c) 2004 - 2017 OfficeHelp.Biz