changing the path behind a button

  • Thread starter Thread starter derksj
  • Start date Start date
D

derksj

Hi

My client had a button in excel 2002 that was linked to an xls sheet on our
server
Now the xls sheet has changed to another directory on this server
My client has now excel 2007 and still has this button linked to te wrong
directory

How can i change the path behind this button in ecxcel 2007?

Greetings
Jurgen
 
I would think that you could change the source of the link using Edit Links
in the Connections group of the Data tab.

--
Jim
| Hi
|
| My client had a button in excel 2002 that was linked to an xls sheet on
our
| server
| Now the xls sheet has changed to another directory on this server
| My client has now excel 2007 and still has this button linked to te wrong
| directory
|
| How can i change the path behind this button in ecxcel 2007?
|
| Greetings
| Jurgen
 

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

Moved spreadsheet changed link path 1
Run a macro from another workbook in the QAT 1
Text box handles 1
how to prevent excel to change hyperlink path towards external fil 3
Is it possible to load sheet without update links? 2
Getting a filename into VBA and putting it into cells 2
Where is toolbar command button to change percentage of screen? 4
Need help using a relative path in VBA 0

Back
Top