Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() on resume next is used to ignore or handle errors yourself if an error occurs the code will continue on the next line in this case the error raised if the password is incorrect is ignored and another try is made. the real bad part of this code is the lack of the statement: Code: -------------------- On error goto 0 -------------------- just before the end of the sub. in this piece of $#%^$%^ you will end up ignoring errors in the rest of your code resulting in very unpredictable results. So take it from me for every _resume_next___ You should have at least 1 _goto_0_ -- Dnereb ------------------------------------------------------------------------ Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182 View this thread: http://www.excelforum.com/showthread...hreadid=392821 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect/unprotect all sheets at once? | New Users to Excel | |||
Protect-Unprotect all the sheets | Excel Worksheet Functions | |||
Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
Protect / Unprotect Sheets | Excel Programming | |||
Protect/Unprotect Sheets | Excel Programming |