hyperlink using buttons

[mallipeddisunil]

iam unable to use hyperlink option to locate files using command buttons


please help me on the same

 

[keymaster]

What do you mean by hyperlink option ? Do you mean ability to click on a link and be able to navigate to another sheet / workbook / or URL ?


Check this if so... http://chandoo.org/wp/2009/02/16/excel-table-of-contents-etc/

 

[mallipeddisunil]

using command button i want to link to another work book stored in another location in hard disk


wheter is it possible?

 

[keymaster]

I am not sure why a command button would be necessary to do this. You can do this with a simple box (Insert > diagram > rectangle). Type some text in the box, like "click here" and then press CTRL+K. In the dialog, select the workbook you want to open.

 

[mallipeddisunil]

thank's a ton........ i forgot about the diagram options


but whether if a sheet(which is source file)is hidden in a workbook and whether it can be opened by using the link

 

[keymaster]

Whether sheet is hidden or not, the references are still valid. So it would work (provided you are able to type in the reference in the hyperlink box) I am not sure about the behavior though... you can give it a try.

 

[mallipeddisunil]

hyperlink on a hidden sheet does not work is there any method to do so


kindly help on the same