Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Custom Toolbars won't work on Company Intranet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Richard - 09 Jan 2006 18:37 GMT
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!!
Dave Peterson - 09 Jan 2006 18:52 GMT
Your life will be much simpler if you create the toolbar (or menu items) when
you open your addin.

Then you won't have to worry about what macro in what workbook is assigned to
each button/item.

If you want to add an option to the worksheet menu bar, I really like the way
John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

> Hi all -
>
[quoted text clipped - 17 lines]
> "S:\\..."  I am wondering if this is the problem - any help with this would
> be greatly appreciated.  Thanks!!

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.