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

See:

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"fahad" wrote in
message ...

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

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" wrote in message ...
See:

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"fahad" wrote in
message ...

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

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

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" wrote in message
...

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