Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2007

Tip: Looking for answers? Try searching our database.

Record Macro in Excel 2007 not recording everything

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Icemokka - 20 Apr 2007 14:55 GMT
Hi,

I've been using Excel 2007 for a few weeks now and I've noticed that
the 'Record Macro' functionality is not so complete anymore.

For example if you record a macro when adding a picture to your
sheet,resizing & moving it, then saving your sheet.
The result is the insert & save sheet code. The resizing & moving of
the picture is not present in the macro.

Another example, add a comment to a cell. Then start recording macro
and change font of this comment. Then you got a nice empty macro.

I hope this is a setting because otherwise I will go back to Excel
2003.
I do a lot of vba automation from VB6 apps and the 'record macro'
function has saved my many many hours already.

Regards,
Sven Peeters
Belgium
Roger Govier - 20 Apr 2007 16:04 GMT
Hi

>Another example, add a comment to a cell. Then start recording macro
>and change font of this comment. Then you got a nice empty macro.

I get identical macros when using the macro recorder to do this with
Xl2202, XL2003 and XL2007.
In no case does the macro recorder show anything about font changes, it
merely shows the text that is in the comment.
Signature

Regards

Roger Govier

> Hi,
>
[quoted text clipped - 17 lines]
> Sven Peeters
> Belgium
Bob Flanagan - 21 Apr 2007 12:33 GMT
Sven, I have seen similar results.  The macro recording feature in Excel
2007 is significantly worse than prior versions. I often have to go back to
Excel 2003 to get usable results, especially with shapes.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

> Hi,
>
[quoted text clipped - 17 lines]
> Sven Peeters
> Belgium
Icemokka - 23 Apr 2007 07:49 GMT
> Sven, I have seen similar results.  The macro recording feature in Excel
> 2007 is significantly worse than prior versions. I often have to go back to
[quoted text clipped - 27 lines]
>
> - Tekst uit oorspronkelijk bericht weergeven -

Luckely we can install 2 versions of Excel ... ;-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.