

June 29, 2013

Hello!
In this example, in the cell M26 of "Model dashboard with numbers" sheet, the formula is linked to IS sheet, but I cannot find any hidden sheet and the file was saved in xlsx format, without macros.
I am wondering if there is a way to hide sheets without using VBA and not linking to an external workbook. The file belongs to a International Monetary Fund free course on http://www.edx.org
Thank you very much for your help to this curiosity
I uploaded the example to Google Drive because the file size surpasses the allowed space.


July 16, 2010

Hi Juan,
Indeed there are many hidden sheets in this file. They are hidden in the Visual Basic editor. If you go to the Developer tab > Visual Basic or ALT+F11 and open the VB Editor you will see the list of sheets in the file.
In the Properties for each sheet (below the Project pane on the left), you'll see the 'Visible' status is set to 0 - xlSheetHidden
When you hide a sheet using this technique it does not appear in the 'Unhide' list when you right-click on the sheet tabs. It also doesn't require the file to be saved as a .xlsm file type.
Mynda
1 Guest(s)
