View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
Default unable to set the locked property of the range class

Ahh...merged cells. Working with merged cells can sometimes be difficult,
but possible. What code did I help you with? Please post all the code and
specify where you are getting the error.

--
Cheers,
Ryan


"Steve" wrote:

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.