Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Toolbar button (Office 97)

    I use the "Paste Link" button quite a bit. (Located under Edit /Paste Special) I have tried to add it to my toolbar and the closest I can get is the "Paste Special". Does anyone know how I can add just the Paste Link function to my toolbar? Thanks!
    Louise

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toolbar button (Office 97)

    Right click on the toolbar and select Customize from the pop up menu. Click on the Commands tab in the dialog box. In the left frame click on Edit. In the right frame, "Paste as Hyperlink" should be about the fifth item down. Drag it to your toolbar.
    Legare Coleman

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toolbar button (Office 97)

    Legare, "Paste Link" and "Paste as Hyperlink" are not quite the same I believe? I may be wrong. I believe that the Paste Link alone does not turn the cell into a Hyperlink. I use Paste as Hyperlink quite a bit as well and have a toolbar button for it. It would just be handy to have the Paste Link button as well.
    Thanks.
    Louise

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toolbar button (Office 97)

    Ah! You are talking about the "Paste Link" button in the Paste Special dialog box. I do not believe that there is a way to get than onto a tool bar.
    Legare Coleman

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toolbar button (Office 97)

    Create this macro:

    Sub PasteLink
    SendKeys "%es%l"
    End Sub

    Create it in your personal macro workbook and attach it to a custom button.

    Remark: Since I used sendkeys (Dangerous sometimes) this only works for English XL!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toolbar button (Office 97)

    Jan Karel's post got me to thinking (woke me up). I prefer this macro to the one he posted since it does not use SendKeys, which as he said can be dangerous:

    <pre>Sub PasteLink()
    ActiveSheet.Paste Link:=True
    End Sub
    </pre>


    Attach that to a button on your tool bar..
    Legare Coleman

  7. #7
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toolbar button (Office 97)

    Ok Guys... now we're going someplace I've never been. <img src=/S/help.gif border=0 alt=help width=23 height=15> <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> Personal Macro workbook?
    I think I'll have to investigate how to build a macro before I attempt to do this. Probably very simple to do but when one hasn't done it.....
    Thanks for your help!
    Louise

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toolbar button (Office 97)

    OK, here is the easy way to create this macro:

    1- Open a new workbook and copy any cell.

    2- In the Tools menu click on Macro and then click on "Record New Macro."

    3- In the dialog box type in a name for your macro, like PasteLink.

    4- In the "Store macro in:" drop down box select "Personal macro workbook."

    5- Click on OK.

    6- Click on the Edit menu, then on Paste Special, then on the Paste Link button.

    7- Click on the Stop Recording button in the tool bar that should have appeard on the screen after step 5. Be careful not to do or click anything else between steps 5 and 7.

    You should now have a macro in your personal macro workbook that you can assign to a button on a tool bar.
    Legare Coleman

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toolbar button (Office 97)

    But mine has one terrific advantage:

    The Undo History is not reset.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •