View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
mangesh_yadav[_101_] mangesh_yadav[_101_] is offline
external usenet poster
 
Posts: 1
Default Controls in protected sheet

Solution (or you can say avoiding the problem):

I might have learned the hard way but maybe thats how it works.
unlinked the cells from the controls and re-linked them through th
code for the control (i.e. on_Click or on_Change). This way it does no
give any error. Only when the control has a cell linked directly throug
its properties, it gives the problem. But without changing anything a
all, I just unlinked it and wrote it down in its code and it work
perfectly fine.

Any comments on this. Anyway thanks for all the help.

Manges

--
Message posted from http://www.ExcelForum.com