Professor Excel

Comments 2

  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.

  2. Anthony

    I am trying to figure out a way to unlock a hidden or locked worksheet by creating an action on the previous worksheet. Is this possible?

Leave a comment

%d bloggers like this: