Hi all -
I have built an application in excel which in its essence is a database of
bonds that our firm trades. I also built a custom toolbar by which end users
will be able to filter and search for certain bonds based on thier desired
criteria.
The toolbar was built using the "View/Toolbars/Customize - add button"
method. I then attached the toolbar to the spreadsheet and saved it. The
toolbar works perfectly on my machine, and it usually works well on any
machine that I email the spreadsheet to. However, when we load the
spreadsheet to the intranet, it initially worked intermittently, sometimes
filtering and sometimes not, and then it just quit. We now get a message
saying the spreadsheet cannot be found.
We have a similar application that we run the same way, which works with no
problems. I noticed that if I go into "assign macros" on the application that
works the macros start with "C:\\..." meaning somehow the macros are housed
on each machine accross the firm. On my application the the macros show
"S:\\..." I am wondering if this is the problem - any help with this would
be greatly appreciated. Thanks!!
Bookmarks