Disable events before doing it

Application.EnableEvents = False

and reset afterwards.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Paige" wrote in message
...
I have a spreadsheet such that when the user clicks on a button (attached
to
a macro), it manipulates the data and inserts columns at specific points.
However, there is a conflict in the process because at one point it says
to
select Column K (to insert another column), and I get an error because in
the
module for that sheet under Worksheet_Change is a macro that runs whenever
any cell in Column K is selected. Is there a way to get around this,
other
than rearranging the format of the spreadsheet itself?