If you paste your data- usuing paste special/ values only then you shouldb e
able to avoid the Error code

"Steve" wrote:

Hi ernie,
Save your personal.xls file as a personal.xlsb format.
It's one of the new eccentricities of excel 2007.
I'd encourage you also to read up on the new formats.
http://www.google.com/search?q=excel...rlz=1I7GGLD_en

If you have any xla formatted files, they become xlam. the new standard
format of xlsx will not allow the user to store macros in the individual
files. The new format for that is xlsm.
Essentiallly, if you want your macros to remain global macros, they need to
be placed in an xlsb file.
hth.
Is so please click yes.
Thanks.
Best.

"Ernie Lippert" wrote:

I recently installed Excell 2007. When Personal.xls [Compatibility Mode]
opens, I get a Microsoft Visual Basic Error 400. The Help menu is not that
much help. What can I do to avoid the 400 error? I have a fairly large amount
of code in different worksheets. Exiting out of the error message box doesn't
seem to do any violence to the execution of the codes.
--
Regards,
Ernie Lippert