Dec 29, 2009 #1 yakpol Structural Jun 1, 2001 450 0 0 CA 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!
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!
Dec 29, 2009 #2 IDS Civil/Environmental Jun 1, 2001 3,201 0 36 AU 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/ Upvote 0 Downvote
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/
Dec 29, 2009 Thread starter #3 yakpol Structural Jun 1, 2001 450 0 0 CA Thanks Doug. I am not going back to 2003 though, It performs funny with windows 7. The sheets in the workbook become transparent sometimes. Upvote 0 Downvote
Thanks Doug. I am not going back to 2003 though, It performs funny with windows 7. The sheets in the workbook become transparent sometimes.
Jan 26, 2010 #4 JTBorton Chemical Jun 9, 2008 21 0 0 DE 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] Upvote 0 Downvote
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]
Jan 26, 2010 #5 IRstuff Aerospace Jun 3, 2002 44,345 4 38 US Windows 7 has settings for making things transparent under certain conditions. TTFN FAQ731-376 Upvote 0 Downvote
Jan 27, 2010 #6 IDS Civil/Environmental Jun 1, 2001 3,201 0 36 AU 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/ Upvote 0 Downvote
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/