View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default how do i protect one cell for write but not for select?

You can lock the cell (format|cells|protection tab|check locked)
then protect the worksheet (tools|Protection|Protect sheet)

If you need code for this, you can record a macro when you do it manually.

jose riu wrote:

I need to write-protect one o more cells , but i need that this cells can be
selectec.
Because i need the activecell address for a macro.

i'll appreciate any help.
--
Jose Riu
Buenos Aires
Argentina


--

Dave Peterson