Thread: VBA to proctect locked cells in sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
dominicb[_39_] dominicb[_39_] is offline
external usenet poster
  
Posts: 1
Default VBA to proctect locked cells in sheet

Good evening SwatspOp

You need this line after your Protect statement:

ActiveSheet.EnableSelection = xlUnlockedCells

This should allow users to flip between unlocked cells only and not
select any locked ones. I think that this feature is only available
from XL 2002 onwards.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=382012

Reply With QuoteReply With Quote