View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim[_39_] Tim[_39_] is offline
external usenet poster
 
Posts: 71
Default Private Sub Workbook_Open() not running on open

Hi All,

I've had a macro working properly for ages, starting automatically (setting
up toolbars etc) on opening using

Private Sub Workbook_Open()

for the last few weeks, it hasn't worked. the only thing i know to have
changed with my system is that all of the company's computers were migrated
to Active Directory (AD)... i know nothing about AD other than it has
stopped me doing all the usual windows customization, can anyone tell me if
it would also prevent auto-open macros from working too? i can run the
macro's manually, so they are still allowed.

any ideas?

thanks,

tim