View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Thiem
 
Posts: n/a
Default Can I allow cell merging in a protected sheet


Format Cells Protection, remove tick in the mark in the "Lock Cell
indicator"only for the cells that you want the users to merge, so by
using your Ctrl+mouse click, on the cells that you want users to merge,
untick or remove the tick for these specific cells, and the protect your
workbook


T


--
Thiem
------------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=493011