couple of questions

[cjbarron5]

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

 

[Mike H]

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

 

[Gord Dibben]

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

 

[cjbarron5]

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

 

[cjbarron5]

I cant find it under addins you may need to email me a copy

 

[Gord Dibben]

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

 

[Gord Dibben]

Can be downloaded from this site.

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


Gord

 

[cjbarron5]

still doesnt work

Can be downloaded from this site.

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


Gord

 

[Gord Dibben]

"still doesn't work" means what?

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

Open Excel and Tools>Add-ins and checkmark it.

Then Data>Template Wizard to open


Gord

 

[cjbarron5]

got it thanks alot......problem was in install location thanks agian

 

[Gord Dibben]

Good to hear.

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


Gord