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!!
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: