Private Sub Workbook_Open() has stopped working (becuase of active directory?)

• Previous message: IDSI: "Re: second domain controller"
• Next in thread: Al Mulnick: "Re: Private Sub Workbook_Open() has stopped working (becuase of active directory?)"
• Reply: Al Mulnick: "Re: Private Sub Workbook_Open() has stopped working (becuase of active directory?)"
• Messages sorted by: [ date ] [ thread ]

Date: Tue, 31 Aug 2004 21:44:55 +0100

Hi All,

[XP Pro, Excel 2002)

I didn't get a response from the excel.vba newsgroup, so maybe you can
help...

I've had a macro working properly for ages, starting automatically (setting
up toolbars etc) on opening an Excel file, 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?

also, on a possibly linked note, a colleague trying to use the same macros
on his laptop just gets an 'Automation Error' message box and so can't run
many / any macros (possibly just ones using custom userforms)

thanks,

tim

• Previous message: IDSI: "Re: second domain controller"
• Next in thread: Al Mulnick: "Re: Private Sub Workbook_Open() has stopped working (becuase of active directory?)"
• Reply: Al Mulnick: "Re: Private Sub Workbook_Open() has stopped working (becuase of active directory?)"
• Messages sorted by: [ date ] [ thread ]