Unprotecting Worksheets in VB Script

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
 
T

Tom Ogilvy

It will work in Excel 97.

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