Unprotecting Worksheets in VB Script

  • Thread starter Thread starter InnerChild
  • Start date Start date
I

InnerChild

I am using this code to unprotect worksheets in a small program I have:

Sheets("Intropage").Unprotect "ugc"

I have since learned, that this does not work in Excel '97. Can anyon
help me out with the command that unprotects password protected sheet
in '97? Is it possible?

Thank
 
It will work in Excel 97.

If you are doing it from a commandbutton, change the TakefocusOnClick
property to false.
 
Back
Top