Thread: lock a font in an order form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default lock a font in an order form
Select the cells to be typed into.

FormatCellsProtectionuncheck "locked"

ToolsProtectionProtect Sheet.

You can type into the cells, but will not be able to change fone color or size.


Gord Dibben MS Excel MVP

On Thu, 5 Oct 2006 08:35:02 -0700, shannon007
wrote:

I want customers to be able to type their information directly into unlocked
cells, but not have the ability to change the font or size. Is this possible?

Reply With QuoteReply With Quote