Excel Experts... (1 Viewer)

[kalli]

Excel Experts... ANOTHER Q ADDED

i have created a button which when clicked i want it to open another spreadsheet...

anyone know the macro code or maybe a forum where i can ask other ppl?

thanks

edit: you know when u load excel the macro warning interface comes up? any ideas on how to DISABLE that? i tried setting the seturity level but it defaults when excel is reopened....

 

[MedNez]

You want to create a hyperlink to the document, which I think with a button is still:

Right click > Create Hyperlink

Then browse for the document you want to link to and press ok.

 

[kalli]

do you know how to make the link.... dynamic-ish?

like if i do that the link will be hardcoded to my computer (i think)... im actually building a spreadsheet for someone else so will eventually have to transfer to their computer...

edit: just tried it and i think this will work... THANKS!