Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
Because I'm a big fan of "Paste Special", I want to have this function as a button on my toolbar. Is this possible? And if so, how do I do this? Thanks Retman |
#2
![]() |
|||
|
|||
![]()
Hi Retman
Rightclick any toolbar. Choose "customize" from the menu that appear. Choose the tab "Commands" in the next dialog. Choose category "Edit". Scroll down to "Paste special" and drag-drop it onto a toolbar. HTH. Best wishes Harald "retman" skrev i melding ... Hello, Because I'm a big fan of "Paste Special", I want to have this function as a button on my toolbar. Is this possible? And if so, how do I do this? Thanks Retman |
#3
![]() |
|||
|
|||
![]()
Thnaks Harald!
One little question about this... now I have a very large button on my toolbar with "Paste special" written on it. Is there any possibility to get an icon/symbol overthere? Retman "Harald Staff" wrote: Hi Retman Rightclick any toolbar. Choose "customize" from the menu that appear. Choose the tab "Commands" in the next dialog. Choose category "Edit". Scroll down to "Paste special" and drag-drop it onto a toolbar. HTH. Best wishes Harald "retman" skrev i melding ... Hello, Because I'm a big fan of "Paste Special", I want to have this function as a button on my toolbar. Is this possible? And if so, how do I do this? Thanks Retman |
#4
![]() |
|||
|
|||
![]()
If you go to ToolsCustomize, then right-click on your button, you will see
a menu with a number of options. Edit button image allows you to design your own image (very crudely) Change button image allows you to pick a new image from a selection provided Copy/Paste button image allows you to copy any existing button's image and paste it onto yours. -- HTH RP (remove nothere from the email address if mailing direct) "retman" wrote in message ... Thnaks Harald! One little question about this... now I have a very large button on my toolbar with "Paste special" written on it. Is there any possibility to get an icon/symbol overthere? Retman "Harald Staff" wrote: Hi Retman Rightclick any toolbar. Choose "customize" from the menu that appear. Choose the tab "Commands" in the next dialog. Choose category "Edit". Scroll down to "Paste special" and drag-drop it onto a toolbar. HTH. Best wishes Harald "retman" skrev i melding ... Hello, Because I'm a big fan of "Paste Special", I want to have this function as a button on my toolbar. Is this possible? And if so, how do I do this? Thanks Retman |
#5
![]() |
|||
|
|||
![]()
While following Harald's instructions, you could also add buttons for
Paste Values, and Paste Formatting. They're nice to have, if you use those commands frequently. retman wrote: Hello, Because I'm a big fan of "Paste Special", I want to have this function as a button on my toolbar. Is this possible? And if so, how do I do this? Thanks Retman -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"paste special" "paste link" | Excel Discussion (Misc queries) | |||
Toolbar button error? | Excel Discussion (Misc queries) | |||
paste special (values) | Excel Worksheet Functions | |||
Paste Special values only | Excel Worksheet Functions | |||
Paste Special | Excel Discussion (Misc queries) |