Hi Guys
I'm relatively new to VB, and also new to this forum, so please forgive me if this is posted in the wrong place.
I am currently trying to add some code to a workbook that will count how many attempts have been made to unprotect a sheet (the sheet is already protected by me).
After x amount of attempts, i would like the workbook to close.
Is there any function I can use??
I understand that it isn't possible to trap an unprotect event... is this correct?
If so, is there a way for excel to listen for errors or events in order to log unsuccessful attempts?
I have tried looking around on the web, but so far haven't found anything useful.
Any help you guys might be able to offer would be really appreciated!
(I'm using excel 2010 if that helps at all.)
Cheers
Matt
Bookmarks