vote up -2 vote down star

Hey guys,

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

flag
Since Stack Overflow is a programming website, I'm afraid this question is off-topic. (But for the record, you can't do no. 1 and you can do no. 2 -- check Excel's help for more information). – Todd Owen Aug 23 at 11:13
...though you can do no. 1 to some extent at least (again, please refer to the online help). – Todd Owen Aug 23 at 11:16

migrated from stackoverflow.com

1 Answer

vote up 1 vote down

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).

link|flag

Your Answer

Get an OpenID
or
never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.