External hyperlink to a specific page in a workbook

N

Nimbus55

I have published an image on the intranet that uses hotspots to take the user
tovarious documents. I have recently consolidated many of the docs into a
single excel workbook - how would I jump from the image to specific pages in
the workbook? I know how to link cell infomation using =sheetx!a2; and I have
tried #sheetx!a2; but I keep getting invalid reference errors! HELP!
 
N

Nimbus55

Update - the formula (workbook.xls#sheetx!A2) works if I disable the
macros...so there is apparently a conflict. The macro simply adds a menu
option that allows my user to save a worksheet as a separate file.
Any way to get around this??
Thanks
 
N

Nimbus55

OK - so now I think I'm barking up the wrong tree - when I am asked to
disable or enable macros and I select disable, the sheet opens correctly -
but if I chose enable, I get an error - if I remove the macro I also get an
error..."invalid reference"...I am going crazy trying to sort this out..all I
want is the ability to go to a specific worksheet from an external hyperlink.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solved Disk Full error message when exporting PDF 0
Hyperlink text from linked workbook 1
Hyperlink to a specific worksheet in another workbook 5
Hyperlink to a specific worksheet in another workbook. 0
Formual link to external workbook 2
Like an image map 2
Hyperlink to specific page in another Word document 1
How do I call number values form one workbook to another workbook 3

Top