Jacob is saying he cannot replicate your problem.

I cannot either. D-click holds until I click to turn off.

Yours does not work properly.

I know of no setting that would disable the format painter functionality.

Try running Diagnostics from ButtonExcel OptionsResources.


Gord Dibben MS Excel MVP

On Thu, 12 Nov 2009 06:18:01 -0800, pj wrote:

Sorry Jacob I dont know what you mean.
I know how the Format Painter is supposed to work because I have 2003 on my
laptop and 2007 on my PC at home and at work. It stays on in the 2003 version
when I double click but not on the 2007 version on both PCs.

Thank you

"Jacob Skaria" wrote:

Tried in 2007 and works similar to 2003

If this post helps click Yes
---------------
Jacob Skaria


"pj" wrote:

I used to be able to double click the Format Painter to paste formatting to
multiple cells but now I'm using Excel 2007 when I double click the Format
Painter the button just pops out so I can only ever past the formatting to
one cell. It only stays in when you press it once.
Is there somewhere else that I have to set this up so that the button stays
in when you double click it?

Thanks