ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 and Autoshapes (https://www.excelbanter.com/excel-discussion-misc-queries/188501-excel-2007-autoshapes.html)

Varne

Excel 2007 and Autoshapes
 
Hello!

If we insert an auto shape in an Excel page whilst the macro recorder is on
the VBA codes will get written on the Visual Basic coding sheets. In 2003
version it happens. I am not able to do it in Excel 2007. Why?

Can an expert clarify this?

Thank You.

Varne M

Jim Rech

Excel 2007 and Autoshapes
 
Microsoft explained during the Excel 2007 beta test that they were not able
to hook up macro recording to the new shapes engine added in that version.
They hoped to be able to do so in Excel 14 but no promises.

--
Jim
"Varne" wrote in message
...
| Hello!
|
| If we insert an auto shape in an Excel page whilst the macro recorder is
on
| the VBA codes will get written on the Visual Basic coding sheets. In 2003
| version it happens. I am not able to do it in Excel 2007. Why?
|
| Can an expert clarify this?
|
| Thank You.
|
| Varne M



Varne

Excel 2007 and Autoshapes
 
Hi Jim

Thanks.

M Varnendra

"Jim Rech" wrote:

Microsoft explained during the Excel 2007 beta test that they were not able
to hook up macro recording to the new shapes engine added in that version.
They hoped to be able to do so in Excel 14 but no promises.

--
Jim
"Varne" wrote in message
...
| Hello!
|
| If we insert an auto shape in an Excel page whilst the macro recorder is
on
| the VBA codes will get written on the Visual Basic coding sheets. In 2003
| version it happens. I am not able to do it in Excel 2007. Why?
|
| Can an expert clarify this?
|
| Thank You.
|
| Varne M





All times are GMT +1. The time now is 04:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com