Hi Bernie,

I think a click event would be best. The user may go into the file more
than once, so I don't want the code to execute every time they close and
save the workbook.

Also, going back to the blank, blank, blank, header issue......is that an
easy modification to your code? It would be interesting to see how you
would make that work.

Thanks again!

-Steph

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Steph,

Do you want a click-event (which is worksheet based) or a before save
event
(which is workbook based)? How they would be added would be dependent on
your choice.

HTH,
Bernie
MS Excel MVP

"Steph" wrote in message
...
Bernie,

I figured out the problem....I had a bunch of hidden sheets. So when I
stepped through you code, I saw that one of the hidden sheets was being
referenced in a variable, and that's when it errored out. So I deleted
all
the sheets, and it works great!! (they didn't need to be there
anyway...there are many steps and files in this process, so while I was
editing this I wanted to keep everything together. In reality, this
particular database file will onlt have the 1 sheet.)

I'm still hoping you can help me with having vba write a click event
procedure in the newly created files. Thanks Bernie!!!!
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Steph,

A database without headers is an _extremely_ BAD thing <vbg.

If you post the code that you wanted to add to the workbooks that are
being
created, on Monday I will modify the code to use four header rows, and
to
add the code to the workbooks as they are created.

Just tell me one thing: when you have your four rows of headers, with
three
rows blank, do you have

Blank
Blank
Blank
Header

or do you have

Header
Blank
Blank
Blank

Talk to you Monday...

Bernie
MS Excel MVP


--
HTH,
Bernie
MS Excel MVP
"Steph" wrote in message
...
Bernie,

Thank you SO much for your help. Would this be easier? Instead of
parsing
the data and creating NEW workbooks, what if I had workbooks already
created
and named as the names in the key column. I could put the headers
there,
and therefore remove them from the database.

Actually, that would make life easier for me, becasue I also needed
to
add
before save events to all the workbooks we were creating. I WAS
going
to
do
that via code, but already having it within the workbook would be a
snap.

Is that easier?

Thanks again!!