Running custom toolbar options in Excel over a network

[asternstein]

I have three PCs on a simple peer to peer network, each running XP Professional and Office 2003 with all updates applied. On the host PC drive, I have an excel workbook in which I have added an option with a number of sub-options to the standard menu toolbar at the top of the workbook (using VB). When I load the workbook and enable macros, the new option appears in the toolbar and the sub-options work. Problem is that when I run the workbook on another PC over the network, the new option does not appear yet the data is that from the host drive. All PCs are runnning the same s/w. The paths point to the right host PC drive and folders.

 

[Dreamboat]

Try this...

http://office.microsoft.com/en-us/assistance/HP052010801033.aspx

"Features that are unavailable in shared workbooks"

Excel VBA Certification is Finally Here!

http://www.vbaexpress.com/forum

Check out this bar:

http://www.ArtBarFtLauderdale.com