Hi there
if I am in a workbook in a cell with the contents:
'worksheet1'!A1
What would I have to put in a macro so that a hyperlink is created, in that cell, to the location 'worksheet1'!A1 (which is in the same workbook)? The macro would be executed while I am in the cell.
So I am after a macro that converts a worksheet/cell reference that is not a hyperlink, into a hyperlink.
Thanks for any help.
Stu
Make sure all the sheet names are surrounded by single quotes as in your example 'worksheet1'!A1
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi alphafrog
I removed the apostrophe from the first line.
The macro creates a hyperlink but it doesn't actually put the reference in the hyperlink (see screenshot pasted in worksheet). You can see this is the case because the hyperlink dialog box screenshot which I put in the worksheet shows that the reference isn't in the field "Type the cell reference:". Do you know why it isn't working?
Thanks! Stu
Please Login or Register to view this content.
Last edited by Stuartzz; 07-07-2018 at 02:13 AM.
Try this. Also, you have to have the sheet name already exist. Your example file doesn't have a sheet named 2plan.
Please Login or Register to view this content.
That's awesome thanks alphafrog!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks