Create "Paste as Hyperlink" VBA
Results 1 to 2 of 2

Thread: Create "Paste as Hyperlink" VBA
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2014
    Posts
    41
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Question Create "Paste as Hyperlink" VBA

    I Tried to use macro recorder but it will not accept the "Paste as Hyperlink" in the menu bar.

    Basically I want to add a "paste hyperlink" Macro/VBA button on a user form. This will allow the user to copy a note they made on another sheet and then paste a link to it in a cell on the form. I do not want to use the "insert hyperlink" command.

    I want to make it very simply "copy" then select cell in the form and select "paste hyperlink" button in the form. (copy and paste will be in the same workbook)

    **IF your up to it a perfect solution would be, to be in the form and then press a add hyperlink macro button and have it display a list of pre-determined sheets so they can select the one with their note. The trick with that would be I only want certain sheets(not all sheets in workbook) to be in the list (and not hidden note sheets).

    Thanks!!
    Last edited by rsjury; Sep 13th, 2016 at 01:45 PM.

  2. #2
    New Member
    Join Date
    Jun 2014
    Posts
    41
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create "Paste as Hyperlink" VBA

    Anyone have any Ideas? Thanks!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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