View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Use Scheuled Tasks to fire Event Code

I've used Scheduled Tasks to open a workbook and run the code in the
"ThisWOrkbook" module as Workbook_Open. You may have to self sign the code
so that it opens without the "Enable Macros" prompt.
--
HTH,

Barb Reinhardt



"ryguy7272" wrote:

I did a little searching and didn't find much on this one. Can I use
Scheduled Tasks to run a snippet of code, which is a private sub, behind a
sheet? If so? How is it done?

Thanks,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.