General Inquiry

Closed
Neo - May 26, 2010 at 08:11 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- May 26, 2010 at 01:41 PM
Hello,

How do I create a hyperlink on a button in excel ?

Thanks

2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 26, 2010 at 08:31 AM
I don't think you can have a hyperlink on a button itself. You can have button assigned to a macro that can open the site
0
Ok. How would I go about doing that ?
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 26, 2010 at 08:54 AM
These lines will open IE

Set IE = CreateObject("InternetExplorer.Application")

IE.Visible = True

IE.navigate "https://www.google.com/?gws_rd=ssl
0
Thanks for your help. I believe i was not detailed enough as to what i would like done.

I basically want to create a shortcut in one file to open another file. I want the link to be placed on the Button. They are both excel files, both are located on the company's public drives.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 26, 2010 at 09:23 AM
It you are trying to open from one excel, another excel file, in that case you have to use

Workbooks.Open ("c:\this is that\myfile.xls")

First you have to create a routine

sub mysub()
Workbooks.Open ("c:\this is that\myfile.xls")
end sub

now right click on button, and choose assign a macro and choose this macro'

Other way can be that you use text as hyper link

So on a cell you can have some this like
2010 Forecast
now right click on the cell and choose hyperlink and add path and file name like
C:\Users\haadi\Downloads\book1.xls
0
thanks, it worked. Is there anyway to protect the button so that no one can delete it, or change the text. The spreadsheet that its in is protected, but you can still right click on the button and make changes.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 26, 2010 at 01:31 PM
never did that. But I would suspect that first you unprotect sheet. Then add the button and assign macro and then look into its properties (right click) to ensure that it is locked and then apply sheet protection. See if it works. Would you please post a message if it works
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 26, 2010 at 01:41 PM
At least in 2007 when you try to protect a sheet, there is option about object. You want to disallow that for user
0