Hide an Excel sheet using VBA in Microsoft Excel and Excel sheet cannot be unhidden using unhide button on Excel application

  In this article, we will create a macro for hiding the Excel sheet. Excel sheet is made hidden by changing its properties using VBA code. Hidd...

Show the full name ( path and workbook name ) in the menu bar in Microsoft Excel

Tip submitted by Kieran from Western Australia. Open the web toolbar. While holding down CTRL and ALT, right-click on the Address box, and drag ...

Opening Workbooks from a List of Hyperlinks

To add a workbook to a hyperlink list: 1. Select a cell. 2. Press Ctrl+K or select the Insert Hyperlink icon from the Standard toolbar. 3. In the...

Dual Monitors - Trouble Displaying separate spreadsheets on each Monitor

Tip submitted by: Judy Cocking, Go to START Menu, open a copy of Excell. It will open on one of your monitors. It does not matter which one. Now,...

Adding the Page Setup Icon to the Excel Menu Bar

To add the Page Setup icon to the Excel Menu bar: 1. Right-click one of the toolbars, and then select Customize from the shortcut menu. 2. In the ...

Changing the Name of the Cell Comment's Author

By default, each cell Comment includes the author's name. To change or cancel the name of the Comment's author: 1. From the Tools menu, select O...

Adding the Camera icon to the toolbar in Excel 2010

Select one of the toolbars and right-click. Select Customize, and then select the Commands tab. From Tools, select Camera, and drag the icon to the to...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube