Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel and Active Directory | Excel Discussion (Misc queries) | |||
Data Connection - Active Directory | Excel Discussion (Misc queries) | |||
Excel active directory | Setting up and Configuration of Excel | |||
Active Directory | Excel Programming |