S
Steve
Morning all.
Using some code from Ryan H. on another post, from yesterday, I've set up my
password protection routine, and am running across a 1004 error.
I keep getting a "unable to set the locked property of the range class."
In reading more on this, it appears that merged cells are my primary culprit
(of which I have many).
While I can remove some, some are necessary due to the operations being
performed with other tasks.
Is there any kind of a work around for this, so it will still perform the
cell/range locking?
Thank you.
Using some code from Ryan H. on another post, from yesterday, I've set up my
password protection routine, and am running across a 1004 error.
I keep getting a "unable to set the locked property of the range class."
In reading more on this, it appears that merged cells are my primary culprit
(of which I have many).
While I can remove some, some are necessary due to the operations being
performed with other tasks.
Is there any kind of a work around for this, so it will still perform the
cell/range locking?
Thank you.