mohankcr
Mar 3, 2010, 01:33 AM
When I open a excel the entier work sheet will be selected and in the excel task it gives the message Select the Destination or paste. Even though I haven't selected anything.
JBeaucaire
Mar 3, 2010, 11:32 AM
Sounds like you have some workbook_event codes recorded into your workbook.
Press ALT-F11 to go into the VBEditor.
Look in the VBAProject panel on the left. You should be able to look inside Sheet modules, ThisWorkbook modules and regular modules (Module1, Module2, etc)... to find the unwanted code.
I would suspect something in ThisWorkbook. Possibly even installed into your PERSONAL.XLS project, if you have one.
Good luck, sleuthing around in there is daunting at first, but you can do it.