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

Hi,

1 can you lock a worksheet automaticly after it has been saved?
It would have to be locked before save or thechanges wouldn't be saved. try
this

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

2 can you create a formula that looks at the whole workbook ? if yes how?
Put a password to open on the workbook and/or repeat the above code for all
worksheets.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
For x = 1 To Worksheets.Count
Sheets(x).Protect Password:="Mypass"
Next
End Sub

3 how many tabs can you have in a workbook?
Workbooks have worksheets not tabs, a tab is used to hold the worksheet name
and provides a few other bits of functionality. The number of sheets is
limited only by available memory.

what I got...............My whole buissnes hinges on excel
This last bit wasn't a question but this would be a very high risk business
strategy because of the very flismy security provided by the solutions
offered above and the risk of data loss.

HTH

Mike

"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

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

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

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

Same old problem.....won't install properly.

I will post a copy to a 'net site then post the URL here for you to download.


Gord

On Sun, 1 Jun 2008 09:47:00 -0700, cjbarron5
wrote:


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

Can be downloaded from this site.

http://www.freefilehosting.net/download/3i1fm


Gord

On Sun, 01 Jun 2008 12:33:56 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Same old problem.....won't install properly.

I will post a copy to a 'net site then post the URL here for you to download.


Gord

On Sun, 1 Jun 2008 09:47:00 -0700, cjbarron5
wrote:


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

still doesnt work
"Gord Dibben" wrote:

Can be downloaded from this site.

http://www.freefilehosting.net/download/3i1fm


Gord

On Sun, 01 Jun 2008 12:33:56 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Same old problem.....won't install properly.

I will post a copy to a 'net site then post the URL here for you to download.


Gord

On Sun, 1 Jun 2008 09:47:00 -0700, cjbarron5
wrote:


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

"still doesn't work" means what?

Just download the file and store in your Office\Library.

Open Excel and ToolsAdd-ins and checkmark it.

Then DataTemplate Wizard to open


Gord

On Sun, 1 Jun 2008 13:24:00 -0700, cjbarron5
wrote:


still doesnt work
"Gord Dibben" wrote:

Can be downloaded from this site.

http://www.freefilehosting.net/download/3i1fm


Gord

On Sun, 01 Jun 2008 12:33:56 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Same old problem.....won't install properly.

I will post a copy to a 'net site then post the URL here for you to download.


Gord

On Sun, 1 Jun 2008 09:47:00 -0700, cjbarron5
wrote:


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

got it thanks alot......problem was in install location thanks agian
"Gord Dibben" wrote:

"still doesn't work" means what?

Just download the file and store in your Office\Library.

Open Excel and ToolsAdd-ins and checkmark it.

Then DataTemplate Wizard to open


Gord

On Sun, 1 Jun 2008 13:24:00 -0700, cjbarron5
wrote:


still doesnt work
"Gord Dibben" wrote:

Can be downloaded from this site.

http://www.freefilehosting.net/download/3i1fm


Gord

On Sun, 01 Jun 2008 12:33:56 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Same old problem.....won't install properly.

I will post a copy to a 'net site then post the URL here for you to download.


Gord

On Sun, 1 Jun 2008 09:47:00 -0700, cjbarron5
wrote:


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

Good to hear.

Good luck with the wizard and creating the database of invoices.


Gord

On Sun, 1 Jun 2008 15:51:00 -0700, cjbarron5
wrote:


got it thanks alot......problem was in install location thanks agian
"Gord Dibben" wrote:

"still doesn't work" means what?

Just download the file and store in your Office\Library.

Open Excel and ToolsAdd-ins and checkmark it.

Then DataTemplate Wizard to open


Gord

On Sun, 1 Jun 2008 13:24:00 -0700, cjbarron5
wrote:


still doesnt work
"Gord Dibben" wrote:

Can be downloaded from this site.

http://www.freefilehosting.net/download/3i1fm


Gord

On Sun, 01 Jun 2008 12:33:56 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Same old problem.....won't install properly.

I will post a copy to a 'net site then post the URL here for you to download.


Gord

On Sun, 1 Jun 2008 09:47:00 -0700, cjbarron5
wrote:


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