View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed[_18_] Ed[_18_] is offline
external usenet poster
 
Posts: 118
Default Create toolbar with VB (notVBA)?

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