View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
[email protected] vitalidade2@gmail.com is offline
external usenet poster
 
Posts: 2
Default Auto_Open one time

I'm relatively new to VBA and I'm trying to write a macro that will
Auto_Open on the first try and place a chart on the excel sheet. I've
gotten Excel (v. 2003) to create and save the chart automatically when
you open the workbook, but the problem is that every time the workbook
is opened the chart is replicated. How can keep the chart from
replicating. In other words, how do I only open the chart
automatically upon opening the file one time? Any advice is greatly
appreciated