Personal.xls macros will not work in any other sheet

Hi

I upgraded from Office 97 to Office 2007. I copied over my previous
personal.xls file to the XLSTART drive, replacing existing one.

The  macros only work on my Personal.xls workbook and not any other ie i get
a message - "Cannot run macro. The macro may not be avaialbe in
this workbook or all macros may be disabled". The macros are not disabled

There must be some setting I can change so they can be used by all workbooks

Thanks

--
Kevin


--
Kevin

maybe this thread will help?

maybe this thread will help?

http://groups.google.com/group/microsoft.public.excel.programming/browse_th=
read/thread/cdf4d46e03fae325/2fce490c07bcb463?hl=3Den&lnk=3Dgst&q=3Dpersona=
l.xls+2007#2fce490c07bcb463

try searching the newsgroup for personal.xls & 2007.  i'm sorry i
don't have the answer for you but maybe can help
anyway................
susan


i get
oks