Page Numbers W/i Spreadsheet

[ChemistB]

I import data into a spreadsheet so there is no way of knowing befor
hand how many pages the sheet will be. I also do not use the Foote
because of its lack of security. Is there a way to have page number
inbedded into the sheet itself? I was hoping to use Excels ability t
repeat rows on each page and put a page number function in one of th
cells in that row but there is no such function. Ideally, I'd lik
page a of b. Thanks in advanc

 

[RagDyer]

Would you care to share with me exactly what concerns you have with using
the footer, as it pertains to security?

 

[ChemistB]

I work in a Federally regulated environment. The Header and footer ar
open to change even when the workbook and sheets are passwor
protected. The only solution I see is to embed the footer informatio
directly into the spreadsheet.

Bill Gates should also make it possible for the author of a spreadshee
to lock in the header/footer information and the Spreadsheet options.
:-

 

[RagDyer]

<<<"The Header and footer are open to change even when the workbook and
sheets are password
protected.">>>

That's *not* true.

You can protect the WB from even being *opened* without a password if you
choose.

 

[Dave Peterson]

I'm betting that ChemistB meant Tools|Protection|protect workbook--not the
file|SaveAs|Tools protection.

 

[Dave Peterson]

One way around it (if you know macros are enabled and events are enabled) is to
plop the header/footer information into each worksheet using the
workbook_beforeprint event.

But this isn't foolproof, either.

 

[ChemistB]

Thanks Dave. Yes, I am talking about protecting what the document
prints out, I don't want to prevent people from using it, or inputting
data. I'm worried about people maliciously altering items in the
header or footer before printing (i.e. date printed if they are filling
out the form late or Version number). Most of these things are easily
imbedding into the spreadsheet itself except for page numbering. I
will look at the workbook_before event. I have a limited knowledge of
Visual Basic but am learning.

Thanks again

Brian