Thread: Can you make a tab entry form in excel like you can in word
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KePaHa KePaHa is offline
external usenet poster
  
Posts: 29
Default Can you make a tab entry form in excel like you can in word
Yes, create the form, then those cells which should remain active for data
entry, highlight them, Format Cells, Protection, Unlock them. Then Tools,
Protect, Protect Worksheet. Then the user can Tab from Unlocked cell to
Unlocked cell.


"lmart" wrote:

I have created tab entry forms in word, is it possible to create these in
excel?
Reply With QuoteReply With Quote