View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta Victor Delta is offline
external usenet poster
 
Posts: 33
Default Help needed with a macro

Oh! Inserted the necessary line and all is now 100%.

Thanks again,

V

"Jim Cone" wrote in message
...
V,
Auto_Open will not run if the workbook is opened via code.
See the RunAutoMacros method.
Jim Cone


"Victor Delta" wrote in message
...
Jim
You are a star. Many thanks.
The macro works perfectly now. However, I have changed the name to
Auto_Open() and curiously it does not run automatically when I open the
spreadsheet. Most odd.
Regards,
V