Hi Marcela

all my macros created in xlsx file format are gone
That's correct
In this file format all macros will be deleted from your file
xlsm is the format with macros


I suggest this

Rename the Personal.xls with your code to myoldpersonal.xls

Creat a new Personal file (see my site)
Open myoldpersonal.xls

When you go to the VBA editor you see both workbooks now
Drag and drop the modules from myoldpersonal.xls to the new Persnoal file

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Marcela" wrote in message ...


"Dave Peterson" wrote:

Shouldn't you be saving that file as personal.xlsb

http://www.rondebruin.nl/personal.htm
(from Ron de Bruin's site)

Marcela wrote: Hi Dave and thank you - so should i re save the personal file? i still have some old macros that i use in that
format personal.xls - also this issie came up 2-3 weeks ago - i have been running Office 2007 for the past 6 months on vista and
never seen this error message. and which is wierd as well - all my macros created in xlsx file format are gone.. all at once 2-3
week ago, thank you


the file you are trying to open, "Personal.xls", is in a different format
than specified by the file extension. Verify that the file is not corrupted
and is form a trusted source before opening the file. Do you want to open the
file now?? // will come up everytime new excel file is opened or xlsx file
type is open. recently reinstalled Office 2007 - it didn't fixed this issue -
any sugestions?

--

Dave Peterson