Dec 29, 2009 #1 yakpol Structural Jun 1, 2001 450 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,287 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 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 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,735 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,287 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/
