Excel 2003 vs Excel 2007

[Keith]

I've have several workbooks that I wrote with Excel 2003. My co-
worker, who is running Excel 2007, can't use the workbook. None of the
Macro's work. Has anyone else run into this problem and is there a way
around this? They're in the process of updating everyone's software. I
should be getting 2007 myself in the next couple of days. I'm worried
none of my workbooks will work.

 

[Ron de Bruin]

Hi Keith

Are the workbooks password protected ?

Maybe ?
http://www.rondebruin.nl/password2007.htm

 

[JP]

In my experience it's usually the other way around

Can you be more specific than "it doesn't work"?

--JP

 

[Keith]

In my experience it's usually the other way around

Can you be more specific than "it doesn't work"?

--JP



- Show quoted text -

Yes the whole workbook is password protected. I have it set up where
the user has to navigate via command buttons. From what i was told by
my co worker, he's not able to use the command buttons to navigate.

 

[john]

I've have several workbooks that I wrote with Excel 2003. My co-
worker, who is running Excel 2007, can't use the workbook. None of the
Macro's work. Has anyone else run into this problem and is there a way
around this? They're in the process of updating everyone's software. I
should be getting 2007 myself in the next couple of days. I'm worried
none of my workbooks will work.

Did you check the security settings in his options? IIRC they're
different in 2007 than in 2003, so you might need to drop that to a
lower setting in 2007.

john
-- freedom is not a concept in which people can do anything they want, be
anything they can be. Freedom is about authority. Freedom is about the
willingness of every single human being to cede to lawful authority a
great deal of discretion about what you do. - Rudy Giuliani

 

[Keith]

Did you check the security settings in his options? IIRC they're
different in 2007 than in 2003, so you might need to drop that to a
lower setting in 2007.

john
-- freedom is not a concept in which people can do anything they want, be
anything they can be. Freedom is about authority. Freedom is about the
willingness of every single human being to cede to lawful authority a
great deal of discretion about what you do. - Rudy Giuliani

Checked the security setting on his cpu. Now some of the macros work.
Still having trouble with some of the Charts though. I have Command
Buttons on the worksheets but I had to use a Form button on the Charts
i have in the workbook. The Form buttons aren't working now. I wish i
could give more examples but since its not on my cpu i can't test. It
could just be something simple i'm missing. Are there any instances
with worksheets or charts where i could possibly have to change the
code to get the macro to work?

 

[Don Guillett]

I have 2003 and 2007. If desired, send your wb to my address below along
with a complete detailed explanation of the problem and I will take a look.