First thanks to all who've helped on this project.
The code I'm referring to is:
activeSheet.Unprotect ("password")
Activesheet.Protect ("password")
And
sheet1.Unprotect ("password")
Sheet1.protect ("password")
and
with activesheet
.unprotect ("password")
.additional code
.additional code
end with
I cannot get either of the above to work in 97. All works great in 2000 but the user of the workbook will be using 97 so I need to find a way to unprotect the sheets when I need to without unprotecting the entire workbook just so he can use it.
I'm at a loss.
The code I'm referring to is:
activeSheet.Unprotect ("password")
Activesheet.Protect ("password")
And
sheet1.Unprotect ("password")
Sheet1.protect ("password")
and
with activesheet
.unprotect ("password")
.additional code
.additional code
end with
I cannot get either of the above to work in 97. All works great in 2000 but the user of the workbook will be using 97 so I need to find a way to unprotect the sheets when I need to without unprotecting the entire workbook just so he can use it.
I'm at a loss.