View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tami Tami is offline
external usenet poster
 
Posts: 123
Default Locking a Spreadsheet but allow inserting

I have a Buyers spreadsheet that the majority of it needs to be
locked/protected. The buyer can then type in the styles names, units, cost
of styles they want to buy..then a bunch of calculations are also on that
same row (e.g. cost * units).
So i don't want them changing column widths, fonts, or typing over formulas
so i want to lock it down excecpt for the few fields that are manual inputs.
But at times they may need to insert rows to add styles.

Can someone help me do this?
Thanks in advance for your help.
thx.
tami