S sstalker77 Mar 18, 2008 #1 I am trying to create a document that others can fill in without altering the original socument can someone help me please
I am trying to create a document that others can fill in without altering the original socument can someone help me please
G Gord Dibben Mar 18, 2008 #2 Pretty difficult to fill in cells without altering the original workbook. I would create a Template then let users do their filling in on a workbook based upon that Template. The Template remains untouched. See Help on Templates. Gord Dibben MS Excel MVP
Pretty difficult to fill in cells without altering the original workbook. I would create a Template then let users do their filling in on a workbook based upon that Template. The Template remains untouched. See Help on Templates. Gord Dibben MS Excel MVP
D David Biddulph Mar 18, 2008 #3 Use Format/ Cells/ Protection to fix which cells are locked. Use Tools/ Protection/ Protect Sheet, to prevent users changing locked cells.
Use Format/ Cells/ Protection to fix which cells are locked. Use Tools/ Protection/ Protect Sheet, to prevent users changing locked cells.