Hello all I am VERY new to the VB coding world and I am trying to create
a workbook with protectedworksheets. I used the code off of
http://exceltips.vitalnews.com/Pages...by_User.htm l
The only difference is that I have about 31 worksheets.

I am able to open the workbook and enter the username password, BUT
when I click ok I get the Runtime Error 9: Subscript out of range
error. When I go to Debug it highlights in yellow this string:
Sheets(sSName).Visible = True

Is there anyone here that can help me out? THank you very much in
advance if anyone can figure this out.


--
Ph8te
------------------------------------------------------------------------
Ph8te's Profile: http://www.excelforum.com/member.php...o&userid=36277
View this thread: http://www.excelforum.com/showthread...hreadid=560573