LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 389
Default VB code is not shown when recording drawing objects

This article confirms it, but it doesn't describe why MS made XL2007 so
lame.

You cannot record new shapes, shape formatting, and shape effects by using
the macro recorder in Excel 2007
http://support.microsoft.com/kb/937620/en-us



--
Tim Zych
SF, CA


"Joakim Norrman" wrote in message
...
For example in Excel 97 when recording creation af a rectangle, following
VB
code was shown:

ActiveSheet.Shapes.AddShape(msoShapeRectangle, 25.5, 26.25, 155.25,
36.75).Select

Does anybody know why this code is not recorded in Excel 2007?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drawing Objects pan65 Excel Programming 4 September 4th 06 03:16 AM
Group drawing objects in VBA Bubb Excel Discussion (Misc queries) 2 April 10th 06 04:22 PM
Cut Drawing Objects within a range CLR Excel Programming 1 January 20th 06 05:31 PM
HOW DO I KEEP DRAWING OBJECTS ANCHORED? HOW DO I KEEP DRAWING OBJECTS ANCHORED? Excel Discussion (Misc queries) 1 May 20th 05 01:35 PM
[Q] parameters to drawing objects Rolf Marvin Bøe Lindgren Excel Programming 1 May 12th 04 10:20 AM


All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"