shortcut for format painter

[fahad]

I need help to assign shortcut key for format painter

[Peo Sjoblom]

See:

http://www.mvps.org/dmcritchie/excel/paste.htm#formats

--
Regards,

Peo Sjoblom

Portland, Oregon




"fahad" <[email protected]> wrote in
message news:[email protected]...
>
> I need help to assign shortcut key for format painter
>
>
> --
> fahad
> ------------------------------------------------------------------------
> fahad's Profile:
> http://www.excelforum.com/member.php...o&userid=30946
> View this thread: http://www.excelforum.com/showthread...hreadid=506181
>

[David McRitchie]

Hi Fahad and Peo,
don't know if I supplied the wrong fragment-id on the link previously or
changed the fragment-id, but make that #painter for the correct link
http://www.mvps.org/dmcritchie/excel/paste.htm#painter
see first item in Related area at bottom of that page if not familiar with using macros.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Peo Sjoblom" <[email protected]> wrote in message news:[email protected]...
> See:
>
> http://www.mvps.org/dmcritchie/excel/paste.htm#formats
>
> --
> Regards,
>
> Peo Sjoblom
>
> Portland, Oregon
>
>
>
>
> "fahad" <[email protected]> wrote in
> message news:[email protected]...
> >
> > I need help to assign shortcut key for format painter
> >
> >
> > --
> > fahad
> > ------------------------------------------------------------------------
> > fahad's Profile:
> > http://www.excelforum.com/member.php...o&userid=30946
> > View this thread: http://www.excelforum.com/showthread...hreadid=506181
> >
>

[fahad]

Thanks for help.



I have visited the link provided by you people and tried it but it didn't work.
What i have done is copy the VBA code for format painter provided in the link in VBA module.

I wrote two names in the worksheet and colored one with green then i press Ctrl+C on green colored name and move to the other name and pressed Ctrl+Shift+P but it didn't work.

Kindly advise and delineate where i was wrong.

regards

fahad

[David McRitchie]

Hi fahad,

Copy the cell you want to copy format from, then select the
cell you want to apply the format to, then ...

From Excel try Alt+F8, look for "PasteSpecialFormats"
if not there you did not install the macro in the correct place
or the workbook that you installed it in (personal.xls) is not hidden.
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Your personal.xls workbook should be in your XLSTART directory
and if you let Excel create it for you, it would have been created in the
correct place.

If it is there try invoking the macro from there with the Run button on right
that might show up a problem such as being in Break mode due to a
previous macro failure. If you get such a error press the Stop button
in the Visual Basic Editor.

Use Alt+F8 select the "PasteSpecialFormats" macro
then Options on the right, make sure that the shortcut key is
in fact Ctrl+Shift+P

On the Excel Window menu, make sure that your personal.xls
workbook is hidden. The reason for hiding is so that you don't have
to specify the workbook name with the macro. With a shortcut key
assigned it really wouldn't matter because the workbook name was included
when you created the shortcut. If you unhide your personal.xls, don't forget to hide it again.

You should be working by now, and perhaps you should review the
directions again in -- if not for yourself then to tell me where confusion
may come from in my directions.
http://www.mvps.org/dmcritchie/excel/paste.htm#painter
http://www.mvps.org/dmcritchie/excel/getstarted.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"fahad" <[email protected]> wrote in message
news:[email protected]...
>
> Thanks for help.
>
>
>
> I have visited the link provided by you people and tried it but it
> didn't work.
> What i have done is copy the VBA code for format painter provided in
> the link in VBA module.
>
> I wrote two names in the worksheet and colored one with green then i
> press Ctrl+C on green colored name and move to the other name and
> pressed Ctrl+Shift+P but it didn't work.
>
> Kindly advise and delineate where i was wrong.
>
> regards
>
> fahad
>
>
> --
> fahad
> ------------------------------------------------------------------------
> fahad's Profile: http://www.excelforum.com/member.php...o&userid=30946
> View this thread: http://www.excelforum.com/showthread...hreadid=506181
>