Record macro in Excel

[yakpol]

It seems Excel 2007 does not record macros while working with shapes and lines. Am I missing something ? Is there a way around it?
Thanks!

 

[IDS]

No, you aren't missing anything.

The way round it is to have an earlier version installed as well (or instead of).

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[yakpol]

Thanks Doug. I am not going back to 2003 though, It performs funny with windows 7. The sheets in the workbook become transparent sometimes.

 

[JTBorton]

What is it you are trying to do? Perhaps we can help, or atleast make fools of ourselves trying.

-JTBorton
Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]

 

[IRstuff]

Windows 7 has settings for making things transparent under certain conditions.

TTFN

FAQ731-376

 

[IDS]

According to this Microsoft blog post:

http://blogs.msdn.com/excel/archive/2010/01/27/programmability-improvements-in-excel-2010.aspx

macro recording of chart and shape operations will make a comeback in 2010, as well as some other VBA enhancements.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/