Log In
Register
Home
June 29, 2013
Offline
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
Offline
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
June 29, 2013
Offline
Hello Mynda,
Thank you very much for your great answer, you always provide the best solutions!
I am impressed to know that it isn't necessary to save the file as xlsm file type when the sheets are hiding in the Visual Basic editor.
Best regards,
Juan
1 Guest(s)
