Due to some conflicts (L-O-N-G story!), I am now trying to use a Visual
Basic app to open an Excel workbook across a network. The workbook
originally had several search functions coded into it; these now must go
into the
VB app. The difficulty is allowing my users to access them. I can
either create a floating toolbar with a
VB form, or create a custom toolbar
in Excel when the workbook is opened.
I've found several examples on creating the toolbar in Excel with VBA, and
I've been told I can manipulate the Excel objects and methods by
VB. So -
theoretically, it should be simple to create this toolbar on the fly when
the workbook opens on the user's system, and delete it when they are done,
right?
Am I jumping into deep waters without my floaties?
Ed