There may be a macro running when you change selection - right-click the
sheet tab, select View Code, and see if there's any code on the
Worksheet_SelectionChange event
Bob Umlas
Excel MVP

"Lynn" wrote in message
...
I double click the format painter & use it once & then it shuts off. How
can
I get it to stay on til I turn it off?
--
- L Fox PMP