I'm having issues with deleting a line of code in my ThisWorkbook Workbook open event. it worked at one time then suddenly it stopped working. It doesn't give me an error when I run the program, but it just doesn't delete the line of code. When I open the sub and step through it I get the error code "Can't enter break mode at this time." I've checked to make sure the line number was 42 & I want to delete only that line. Here is the code:
Help will be appreciated
Edited: If I step through the file and get the error then hit continue or end it deletes the code like it should... but does not go to "End With"
I tried to input the line "On Error Resume Nest to try to override the error...well that line of code doesn't work on anything that I've tried
Going to bed...will check back tomorrow if anyone can help
Please Login or Register to view this content.