View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian Ian is offline
external usenet poster
 
Posts: 238
Default Default Tab Stops for Template

You need to unprotect the cells you want to tab into
(FormatCellsProtection deselect Locked)and protect the
sheet(ToolsProtectionProtect Sheet).

--
Ian
--
"IMATech2" wrote in message
...
I built an invoice template in Excel, everything works except I want to tab
over the cells that are just labels and goto the fields that need data
inserted.
Is there a way to do this like the prebuilt MS templates or do I have to
program a user form with VB?

Thanks