Is Roster the activesheet? If so

try

ActiveSheet.Unprotect . . .

--
Regards,
Tom Ogilvy


"Ardy" wrote:


Hello All

If I am using this code ActiveWorkbook.Worksheets("Roster").Unprotect
"Password" How would I automatically get the tab name to input in
Worksheets("Roster"). Portion of the code.

Ardy