Reply to thread

Message: [QUOTE="c1802362, post: 7402382"] My company just upgraded my computer from Windows XP/MS Office 2003 to Windows 7/MS Office 2007. As I revalidate all the VBA code I've written in Excel, Powerpoint, and Word, I'm finding some disturbing issues. Can anyone give me some guidance the following issues: 1) in Excel 2007, any routines I have that manipulate drawing objects (creating, modifying, moving around) still work, but when I try to record (usingthe macro recorder) any actions involving drawing objects, the system won't capture them. So, for example, in Excel 2003, if I create a text box and format it with the macro recorder turned on, the system will write the following to a new subroutine ("Macro1"): Sub Macro1 ActiveSheet.Shapes.AddTextbox(msoTextOrientationHorizontal, 100, 100, 30, 50).Select Selection.Characters.Text = "demo" With Selection.Characters(Start:=1, Length:=5).Font .Name = "Arial" .FontStyle = "Regular" .Size = 10 .ColorIndex = xlAutomatic End With End Sub Nothing happens in Excel 2007 Similarly, if I turn the recorder on again and select the text box and moveit around the sheet, nothing is recorded in the subroutine. However, if I click in a cell, the recorder wakes up and tells me I've selected a range object [Range("A1").Select] 2) Powerpoint 2007 is even worse. There is no macro recorder anymore... The issue is that creating drawing objects is not an everyday occurrence, so its easier to have the system capture the basic code than trying to type the syntax from memory. Does anyone know if Excel 2010 puts the VBA functionality lost from 2003 to2007 back in? (The reason I ask is my company's IT department has told me that due to problems with 2007 they'll be upgrading me again in about 6 months to 2010) Art [/QUOTE]

Verification