Professor Excel

Comments 1

  1. JohnnyNoBrakes

    To unhide the sheets you can rename the workbook to zip, extract, remove all of the state=”veryHidden” attributes from the sheets in xl\workbook.xml, save, re-package up (windows explorer and 7Zip failed, but .Net’s ZipFile.CreateFromDirectory which requires a reference to the System.IO.Compression.FileSystem assembly worked), and then rename back to xlsm. If the startup code hides the form then you will need to open Excel, File->Open, browse to the file, hold SHIFT, and open the file to prevent the startup code from running.

Leave a comment