Ian Mangelsdorf wrote:
Ive made the changes but am now getting another @!#$@ error


Is the macro triggered by a Control Toolbox command button?
If so, set its TakeFocusOnClick property to False.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup