| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro programing in excell | Excel Programming | |||
| excel 2007 macro/vb programing question | Excel Programming | |||
| Excel 2007...what is the main programing tool | Excel Discussion (Misc queries) | |||
| Macro Programing | New Users to Excel | |||
| Macro programing | Excel Programming | |||
Hybrid Mode
