Record macro in Excel

• Dec 29, 2009

• #2

IDS

Civil/Environmental

Jun 1, 2001

3,291

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

• Dec 29, 2009

• Thread starter
• #3

yakpol

Structural

Jun 1, 2001

450

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

• Jan 26, 2010

• #4

JTBorton

Chemical

Jun 9, 2008

21

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

• Jan 26, 2010

• #5

IRstuff

Aerospace

Jun 3, 2002

44,889

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,291

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