excel - Prevent the macro break for pass-protected self-destructing file -
i've decided create pass-protected file self-destruct after 3 wrong password entries. macro runs file open (userform pass entry field pops up) weak point ctrl-break allows stop macro , access code. is there way disable/prevent break option in particular workbook (via vba, preferably)? if interested, can provide macro upon request. upd: here's macro i'm using (date based). private sub workbook_open() if date > cdate("30/03/2015") warning.show end if end sub this part of code assigned "ok" , "cancel" buttons of userform "warning". public integer public b integer sub setib() = 2 - b b = b + 0 end sub private sub cnclbtn_click() warning.hide thisworkbook .saved = true .close false end end sub private sub okbtn_click() call setib dim pass string: pass = "*your pass*" dim passinput string: passinput = warning.passfield.text if passinput = p...