Excel 2007 Macro Programing
 

I have just upgraded to Office 2007 (not by choice). I am having
trouble with the macros that I used in my 2003 version. My macros
select shapes and then make them invisible or visible plus formats
them. My 2003 macro does not work and I can not seem to record a
macro in 2007 that will help me with the syntax. Help!

Excel 2007 Macro Programing
 

Eddie,

You are right that XL 07 macro recorder doesn't deal with shapes. I've seen
various discussions. Google "excel macro recorder shapes" to read some of
them. Be sure to note the tool on the Newton Excel Bach site.

Good luck!

Doug

"Eddie Kirby" wrote in message
...
I have just upgraded to Office 2007 (not by choice). I am having
trouble with the macros that I used in my 2003 version. My macros
select shapes and then make them invisible or visible plus formats
them. My 2003 macro does not work and I can not seem to record a
macro in 2007 that will help me with the syntax. Help!

Excel 2007 Macro Programing
 

Not selecting them is a solution in 2007

See
http://www.rondebruin.nl/shape.htm



--

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


"Eddie Kirby" wrote in message ...
I have just upgraded to Office 2007 (not by choice). I am having
trouble with the macros that I used in my 2003 version. My macros
select shapes and then make them invisible or visible plus formats
them. My 2003 macro does not work and I can not seem to record a
macro in 2007 that will help me with the syntax. Help!

Excel 2007 Macro Programing
 

Oops

Not selecting them is a solution in 2007

Must be

Not selecting them is a solution in 2007 if you want the code to run fast.


--

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


"Ron de Bruin" wrote in message ...
Not selecting them is a solution in 2007

See
http://www.rondebruin.nl/shape.htm



--

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


"Eddie Kirby" wrote in message ...
I have just upgraded to Office 2007 (not by choice). I am having
trouble with the macros that I used in my 2003 version. My macros
select shapes and then make them invisible or visible plus formats
them. My 2003 macro does not work and I can not seem to record a
macro in 2007 that will help me with the syntax. Help!