Excel 2003 macros not available in Excel 2007?

  • Thread starter Thread starter Mr Web
  • Start date Start date
M

Mr Web

My new Excel 2007 accepts old Excel 2003 files but there is two problems:

1) I can't use 2003 VBA macros at all when having translated to new file
version. I put every where in the settings that please accept all macros etc.
but it didn't help. I can't use macros made earlier.

2) I could use macros in Office97/2003 mode but then Conditional formatting
was impossible. The size of the file was ten times bigger when the program
started to generate new rules all the time. Finally the whole program stopped
working. So I had to use new 2007 file version and make those conditional
formatting rules again. But then I have that macro problem (see problem
number 1).

Do I have to rewrite all my macros too?
Does anyone know a solution?
 
Hi Jan

Thanks a lot. I removed the file open password and all macros work fine! But
is there any reason for that kind of functionality or restriction? My file is
very confidential but I really need those macros too in order to be more
efficient. Do I have to take password away and put back every time I want to
use my macros? Unbelievable if so!

Mr Web

---
 
Back
Top