OK this is the weirdest thing. I just got a new laptop with Win 7 installed. (Yes we buy old products for new machines to save money.) anyway, this is not my choice.
On my XP machine i had a simple paste/special values macro i put in my quick access toolbar because i do a lot of copy/paste. it worked fine before. Now that i have Win7, the macro completes the paste option properly but then gives me a pop up box with the "Application-defined or object-defined error". When I run the code from VBA either by stepping through it manually or by using the run button i do not get this error. The error only happens when i use the button on my quick access toolbar.
Any suggestions to help me resolve this is appreciated. (And no comments about buying old OS for a new machine. lol)
Thank you Sincerely,
Jeff
On my XP machine i had a simple paste/special values macro i put in my quick access toolbar because i do a lot of copy/paste. it worked fine before. Now that i have Win7, the macro completes the paste option properly but then gives me a pop up box with the "Application-defined or object-defined error". When I run the code from VBA either by stepping through it manually or by using the run button i do not get this error. The error only happens when i use the button on my quick access toolbar.
Any suggestions to help me resolve this is appreciated. (And no comments about buying old OS for a new machine. lol)
Thank you Sincerely,
Jeff