Excel 2003 macros not available in Excel 2007?

[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?

 

[Jan Karel Pieterse]

Hi Mr,

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.

Macros do not work with xlsm files that have a file open password.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Mr Web]

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

---

 

[Jan Karel Pieterse]

Hi Mr,

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!

I agree this is a royal PITA and have already submitted a bug report to MSFT
about this. In fact it renders protected Excel files with VBA useless as far as
I'm concerned.

As a side note, I rely on just Excel's protection if I need to keep confidential
data if I were you, rather make sure you arrange access to the workbook using
other means, such as access rights to the (possibly encrypted) folder where it
is saved.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Jan Karel Pieterse]

Hi Jan,

I rely on just Excel's protection if I need to keep confidential
data if I were you

Duh, I meant to say:

I *would not* rely on just Excel's protection if I need to keep confidential
data if I were you

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com