0

Sorry for my second Excel question in as many days! Almost there now though :)

I've created a template for an invoice for my mum... is there anyway I can sort of lock the file, and create sub invoices from it, hopefully achieving...

  1. Any changes made to the default/master invoice will reflect on all of the others
  2. Locking down the spreadsheet so she can only edit certain columns? :D

Any suggestions would be fantastic, thanks

1 Answers1

1

You can "save as" template. When Mum double-clicks the doc, that will create a fresh unsaved doc. which is a copy of the template.
In xl, all cells are by default "locked", but you won't see it until you protect the sheet.
So, first, unprotect the input cells (that's in the Format, cells), then lock the sheet (that's in format, sheet).

Patrick Honorez
  • 646