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.

Hi Keith

Are the workbooks password protected ?

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



--

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


"Keith" wrote in message ...
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.

In my experience it's usually the other way around :-)

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

--JP

On Jul 24, 11:21*am, Keith wrote:
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.

On Jul 24, 11:40*am, JP wrote:
In my experience it's usually the other way around :-)

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

--JP

On Jul 24, 11:21*am, Keith wrote:



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.- Hide quoted text -

- 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.

On Jul 24, 11:46*am, john wrote:
On Thu, 24 Jul 2008 08:21:54 -0700 (PDT), Keith

wrote:
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

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?

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Keith" wrote in message
...
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.