Tip & How-To about Microsoft Excel for PC

Excel- Unhide All Sheets

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.
```Sub sbVeryHiddenSheet()
Sheets("SheetName").Visible = xlSheetVeryHidden
End Sub
```

Posted by on

Related Questions:

how to calculate the percentage using the excel

Hide All
Percentages are calculated by using the following equation:
amount/total = percentage
Where percentage is in decimal format.
What do you want to do?

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.

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
1 2 A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay (\$71.20) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?
Example The example may be easier to understand if you copy it to a blank worksheet.
1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

Simple way Amount/Total*100

Apr 30, 2011 | Computers & Internet

Hi, If you are receiving Error 8e5e05f6 when you sign into Windows Live Messenger 2009, please try the following:

1. Enable Hidden Files and Folders:
1. A. Windows XP :
1. a.i. Click on “Start”, click “My Computer”
1. a.ii. On the “Tools” menu, click on “folder options”.
1.a.iii. On the “view” tab, locate “Advanced settings” and then follow these steps:
Check the option “Show Hidden files and folders”
Clear the option, “Hide protected operating system files check box”.
Clear the option, “Hide file extensions for know file types check box”.
1. a.iv. Click ok and close the window.
1.B. Windows Vista :
1.b.i. Click on “Start”, click “My Computer”
1.b.ii. In the Explorer window, click “Organize”
1.b.iii. Choose “Folder and Search Options”.
1.b.iv. In the folder options window, click on “View” tab
1.b.v. Select the option “Show hidden files and folders” click “ok”.

2. Delete Windows Live Contacts folder :
2. a. Click on “Start”; double click on “My computer”
2. b. Browse to the location
Windows XP:
C:\Documents and Settings\<Your Windows logon name>\Local settings\Application Data\Microsoft
Windows Vista:
2. c. Delete “Windows live contacts folder” completely.
Note: Ensure to exit Windows live Messenger from the task manager before deleting Windows live contacts cache folder, otherwise you will get an error prompting that you can’t delete the folder .
2. d. Try signing into Windows Live Messenger.

Sep 19, 2009 | Microsoft Windows Live Messanger

how do I fix Error 8E5E05F6

Try the following:

1. Enable Hidden Files and Folders:
1. A. Windows XP :
1. a.i. Click on “Start”, click “My Computer”
1. a.ii. On the “Tools” menu, click on “folder options”.
1.a.iii. On the “view” tab, locate “Advanced settings” and then follow these steps:
Check the option “Show Hidden files and folders”
Clear the option, “Hide protected operating system files check box”.
Clear the option, “Hide file extensions for know file types check box”.
1. a.iv. Click ok and close the window.
1.B. Windows Vista :
1.b.i. Click on “Start”, click “My Computer”
1.b.ii. In the Explorer window, click “Organize”
1.b.iii. Choose “Folder and Search Options”.
1.b.iv. In the folder options window, click on “View” tab
1.b.v. Select the option “Show hidden files and folders” click “ok”.

2. Delete Windows Live Contacts folder :
2. a. Click on “Start”; double click on “My computer”
2. b. Browse to the location
Windows XP:
C:\Documents and Settings\<Your Windows logon name>\Local settings\Application Data\Microsoft
Windows Vista:
2. c. Delete “Windows live contacts folder” completely.
Note: Ensure to exit Windows live Messenger from the task manager before deleting Windows live contacts cache folder, otherwise you will get an error prompting that you can’t delete the folder .
2. d. Try signing into Windows Live Messenger.

Sep 19, 2009 | Microsoft Windows Vista Home Premium with...

cannot insert columns in excel spreadsheet. Comes up with error cannot shift object off sheet

This error message occurs if the following conditions are true:
• The option Nothing (hide objects) is selected in the Display options for this workbook section in the Excel Options dialog box.
• You create an object, such as a cell comment, in any cell in a column.
• You try to hide the column to the left of the column that contains the object, the column that contains the object, or all the columns to the right side of the column that contains the object. Or, in some cases, you try to insert a row or column in the worksheet.
There are two ways to fix this problem.
Method 1:  Temporarily toggle the option from "Nothing (hide objects)" to All In Excel 2007, temporarily toggle the option from Nothing (hide objects) to All, and then insert the rows or columns as needed. To do this, follow these steps:
1. In the upper-left corner of the Excel window, click the Microsoft Office button.
2. At the bottom of the menu, click Excel Options.
3. Click Advanced from list of options on the left.
4. Scroll down to the Display options for this workbook section, and then click All under For objects, show:, and then click OK.
Notes To use the keyboard shortcut to toggle this selection, press CTRL+6.
If these steps do not let you hide rows or columns or insert rows or columns in Excel 2007, try the steps in method 2.
Method 2: Change the position property of the object to Move and size with cells To work around this issue, Excel 2003, Excel 2002, and Excel 2000, change the position property of the object to Move and size with cells. To do this, follow these steps:
1. If the object is a cell comment, select the cell that contains the comment, right-click the cell, and then click Show Comment or Show/Hide Comments. Note This makes the comment visible.
2. Move the pointer to the edge of the object until the pointer changes into a white arrow with four small black arrows on the pointer. Then, click the object to select it.
3. In Excel 2003 and earlier version of Excel, click <object name> on the Format menu. Note In this menu command, <object name> is the name of the object, such as "Comment" or "AutoShape."  In Excel 2007, click Format <object name>.
4. In the Format dialog box, click the Properties tab.
5. Click Move and size with cells, and then click OK.
6. If you want to hide the cell comment again, right-click the cell that contains the comment, and then click Hide Comment.
7. Follow these steps for each object in the affected column as described in the "Cause" section. When you hide the columns, you do not receive the error message.

Nov 06, 2008 | Computers & Internet

Not finding what you are looking for?

468 people viewed this tip

Level 3 Expert

Level 3 Expert