View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert[_16_] Robert[_16_] is offline
external usenet poster
 
Posts: 29
Default xlUnlocked Cells Not Working

I have a file where sheet 1 is protected but has two unlocked cells. I have
set in VBA browser the EnableSelection to xlUnlockedCells.

Returning to the spreadsheet, sheet 1 correctly only allows movement between
the two unlocked cells. However, if I close the file after saving, when
opened the xlUnlockedCells has been turned off.

Any ideas?

Thanks, Robert