Tip & How-To about Microsoft Excel for PC
Advanced Hide Options
When we hide worksheets using, still user can right click on tabs and un-hide the worksheets. For example, following example will hide the worksheet and user can un hide the sheets on right click on sheet tabs:
Sub sbHideSheet() Sheets("SheetName").Visible = False 'OR Sheets("SheetName").Visible = xlSheetHidden End Sub What if you do not want to permit users to un-hide worksheet, you can set the Visible property of worksheet to xlSheetVeryHidden and lock the VBA code. so that user can not un-hide the worksheet. The below example will hide the sheet and user can not see it in un hide worksheet dialog list.
Sheets("SheetName").Visible = xlSheetVeryHidden
Posted by Mohd... on
Calculate the amount if you know the total and percentage For example, if you purchase a computer for $800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.
Example The example may be easier to understand if you copy it to a blank worksheet.
Apr 30, 2011 | Computers & Internet
Sep 19, 2009 | Microsoft Windows Live Messanger
Sep 19, 2009 | Microsoft Windows Vista Home Premium with...
Nov 06, 2008 | Computers & Internet
468 people viewed this tip
Usually answered in minutes!