K
Keith
I have a worksheet that has protection switched on. When a certain routine is
run I need to turn the protection off do the routine then turn it back on
again.
When I initially protect the worksheet I need to set the Edit Objects so
that my routines will run properly.
Unfortunately I can't seem to set that back on again when I turn the protect
back on inside my code.
Is there a way to turn the protect back on and use edit object from within
VBA?
run I need to turn the protection off do the routine then turn it back on
again.
When I initially protect the worksheet I need to set the Edit Objects so
that my routines will run properly.
Unfortunately I can't seem to set that back on again when I turn the protect
back on inside my code.
Is there a way to turn the protect back on and use edit object from within
VBA?