In Excel 2003, I could record a macro while creating objects and all worked well. Unfortunately, 2007 is a different animal! When I record a macro, everything is recorded EXCEPT the act of creating objects. There must be a setting somewhere in 2007 that causes the action of creating objects to be recorded. Any help would be appreciated.
thanks,
thanks,