Format Painter won't stay on

L

Lynn

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?
 
N

Niek Otten

Click once and it will "shut off" after one use. Double-click and it should
stay on.

No other problems with double-clicks?
 
N

Niek Otten

<Is there an option that I need to set?>

Not that I know of. But I think this option has not always been present in
Excel. Do you happen to use an old version?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Lynn said:
No other problems with double click. Is there an option that I need to
set?
Click to expand...
 
B

Bob Umlas

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Painter overwrites text 4
remove Format painter icon on speardsheet 2
Inserting Rows...but losing "FORMAT" 1
Format Painter and the Styles 1
clipboard and format painter 1
Excel 2007, Conditional Formatting, Format Painter 3
Format Painter Column Width 3
Copying Conditional formatting 2

Top