View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Paul Viel Jean-Paul Viel is offline
external usenet poster
 
Posts: 39
Default Run Macro when workbook opens

Hi,

Put our macro into the module « ThisWorkbook ». with the combo boxes on top,
first choose Workbook and then open.


--
JP

http://www.solutionsvba.com


"Gary" wrote in message
...
I'm using Excel 2000 on Win XP and have a form created in
VB that writes to a spreadsheet. What I want is to run
the macro that opens the form when someone enters the
workbook. I've tried auto_open and autorunmacro but I
must be doing something wrong with them as it does not
seem to work. I am new to VB so it is probably something
simple I am not doing.

Thanks in advance for any help provided.

Gary