If you look, you will see you don't. I don't doubt that you do actually
have it, but periods on the left margin can get removed in postings.

in the VBE, go to the projecte explorer Ctrl+R if it isn't visible. Under
your workbook name, you should find an entry ThisWorkbook. Double click on
that or right click on it and select view code to get to the ThisWorkbook
module

In the left dropdown at the top, select Workbook and in the Right select
Open.

This shoul put in the proper declaration for the workbook_Open event. This
is the way you should enter event macros. No you can put your code in this
procedure.

--
Regards,
Tom Ogilvy


"CWit " wrote in message
...
if you look at the code i posted it has period before CenterFooter...

I just can't seem to find the "Thisworkbook"

I'm such a N00b!


---
Message posted from http://www.ExcelForum.com/