Thread: Auto_open MAcro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John McCabe John McCabe is offline
external usenet poster
 
Posts: 18
Default Auto_open MAcro

I have a TOC(table of contents) macro and it works great. Also have the
auto_open macro to start on the first sheet.
Trying to give users the option of creating the TOC sheet and then of course
always start on that sheet. But would have NO auto_open unless they
actually want the TOC sheet to be there. Somehow is there a way to have the
TOC macro create also the auto open macro