active directory?
 

hi [XP Pro, Excel 2002]

i've had a spreadsheet for a while which logs my work. it has a custom
toolbar attached with code to: -
-on opening the workbook, make the bar visible (and turn off standard &
formatting toolbars)
-on deactivating / moving to anotehr workbook, make that bar invisible and
make the standard ones visible again (ie, reverse of above)
-on activation / switching back, make the bar visible (and turn off standard
& formatting toolbars) (ie, same as the first one)

it all worked fine until my pc was 'migrated' to active directory (work
laptop), now none of these events happen. the toolbar is in the list of
available toolbars and when selected, appears & works fine... does anyone
have experience of this sort of thing happening - is it likely to be due to
active directory and is there anyway of fixing it?

on a separate note, i have a macro within the same workbook that pulls
together data from the row of the active cell, creates a word document (from
report templates) and hyperlinks the active cell to the word document, this
also works fine BUT upon re-opening the workbook, the hyperlink has changed
"[" to "%5b" and "]" to "%5d" which i presume is some character code for
those symbols, this obviously means the hyperlink no longer finds the
correct file. if i re-run the hyperlink macro, it renames correctly and
everything is fine again until the next time i open the workbook. so my
question is, why is it happening and how can i stop it? it hasn't always
done this, but i think it DID happened prior to active directory (i can't
remember any specific thing which might've triggered it to happen). all
files are on a network drive (don't know if this is significant).

maybe i should look for an active directory ng, but i don't want to cross
post and it is excel that i am having problems with.

many thanks for any help,

tim