View Single Post
 
Old 07-20-2017, 12:18 PM
JohnGanymede JohnGanymede is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jul 2017
Posts: 9
JohnGanymede is on a distinguished road
Default

...also
Code:
If WorksheetFunction.CountA(.Range("C5:C14")) = 0 Then Exit Sub
This is way more elegant that what I tried, which involved a conditional goto statement about the debugger, after the unprotect, with the goto target dropped into the macro just before the "protect sheet" statement at the end. Something I copied off the internets... Yours will stop the debugger from launching at all, before the sheet is unprotected.
Reply With Quote