If ActiveCell has a comment then exit sub
On Monday, January 12, 2015 at 7:57:01 PM UTC-8, GS wrote:
I see you commented out the protection code. You do know that VBA works
on protected sheets when this parameter...
UserInterfaceOnly = True
..is set, right? Note that this is non persistent between sessions and
so protection must be reset (removed then replaced) at startup!
--
Garry
No, I did not know that. Have not heard of it.
How would it be used in this code, perhaps like EnableEvents False/True at the beginning and end?
Howard
|