View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Restrict User to specific cell

Select that cell

FormatCellsProtection, and unclick Locked

Protect the sheet, ToolsProtectionProtect sheet...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
I would like to run a worksheet where the user is only allowed to input
data in a specific cell, ...say B5.