We've just had Office 2007 rolled out across our company, and now my trusty signature macro (As explained in click here) is gone. Or was. I tried to do the same thing in Excel 2007 as I had done in '97, but the macro recorder would not pick up the 'Insert picture' steps. I started new macro, entered name/info etc and went through the insert picture moves from the ribbon, but when I stopped macro recorder, and looked at the code for macro, all that was there was start, info that I'd added and end, nothing in between. Luckily I still have '97 on my pc, so did it again in that, to check I'm not mental, and all worked fine, tried again in 2007, and it doesn't grab the insert picture steps. I've worked around it by copying the code across from '97 VBE into my 2007 macro, so my macro is now working OK in 2007, but I'd like to know how it should be done in 2007, as eventually, we will have '97 uninstalled. Any ideas? Cheers
The code I have works fine, I copied across the code from '97 into the VBA window in 2007, and works perfectly. My problem is how to create a new macro using the macro recorder in 2007. It just seemed to ignore me selecting Insert>picture>etc, it didn't seem to 'see' me clicking on those controls. I can happily make macro's on 97 and copy the code across to 07, at the moment, but we will, at some point, remove 97 from our machines. I hope that's a clearer explanation, I know what I mean, but don't always explain very well.