| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Excel Runtime Error 9: Subscript out of range
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Runtime Error 9, Subscript Out of Range. When linking between word | Excel Discussion (Misc queries) | |||
| Subscript out of range error - save copy error | Excel Programming | |||
| Type Mismatch error & subscript out of range error | Excel Programming | |||
| "Subscript out of range Runtime Error 9" | Excel Programming | |||
| Excel Macro Problem, Add-in need to work in every workbook & Error:9 Subscript out of range | Excel Programming | |||
Threaded Mode
