I cant find it under addins you may need to email me a copy
"cjbarron5" wrote:

I downloaded it but where does it install it to or do you access it from
excell?

"Gord Dibben" wrote:

1. You cannot save a worksheet.........only can save a workbook but you could
protect a worksheet when you save the workbook.

You would need VBA event code such as

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
Sheets("Sheet1").Protect Password:="justme"
End Sub

2. Yes =SUM(Sheet1:Sheet20!A1) will sum all A1's on all sheets.

3. As many as your resources will allow.

Sounds like you have a job for the Template Wizard with Data Tracking add-in.

There is a download on the MS site at

http://support.microsoft.com/kb/873209/en-us

If it won't install, post back and I can email you a good copy of the Wizard.


Gord Dibben MS Excel MVP


On Sun, 1 Jun 2008 07:08:00 -0700, cjbarron5
wrote:

1 can you lock a worksheet automaticly after it has been saved?
2 can you create a formula that looks at the whole workbook ? if yes how?
3 how many tabs can you have in a workbook?

what I got...............My whole buissnes hinges on excel, inventory,
billing ect i would use access but I just dont "get it" anyway I want to
beable to "write" a quote invoice,save that invoice and search those
invoices. the invoice sheet is made and works great but it is one sheet out
of about 20 in the workbook. any ideas?
thanks
chris