nikki333
11-08-2019, 01:17 PM
Hi Folks
I'm tring to let the user select rows within a table and to give a feedback via cell color change. However, this is to happen on a locked worksheet.
Therefore, I've added an event procedure (double click) that unlocks the worksheet at the top of the procedure and lock it again before exiting the procedure.
This is all working as expected, but when the locking statement is carried out, a message box pops up, saying that my sheet is protected and blabla. But, actually, at that point the procedure did it's job; so it's only the annoying message I'd like to get rid off. I've tried "Application.DisplayAlerts = False", but that has no effect.
Any ideas?
Cheers
I'm tring to let the user select rows within a table and to give a feedback via cell color change. However, this is to happen on a locked worksheet.
Therefore, I've added an event procedure (double click) that unlocks the worksheet at the top of the procedure and lock it again before exiting the procedure.
This is all working as expected, but when the locking statement is carried out, a message box pops up, saying that my sheet is protected and blabla. But, actually, at that point the procedure did it's job; so it's only the annoying message I'd like to get rid off. I've tried "Application.DisplayAlerts = False", but that has no effect.
Any ideas?
Cheers