View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wrkoch[_3_] wrkoch[_3_] is offline
external usenet poster
 
Posts: 1
Default Disable Auto_Open with VBA

I have an auto_open macro I would like to run only once. Ever.

Is there a way to diable this event programmatically? I thought abou
embedding code in the Window_open event to turn off the Auto_Ope
event.....

Yes, I could just set a cell value but I'm looking for ways to do i
without modifying the content of the spreadsheet. I could use
variable to stop the processing I want done but I can't seem to fin
one that remains behind when the workbook/application closes.

Thanks in advance for your help!

Warre

--
Message posted from http://www.ExcelForum.com