Justinlabenne
03-22-2005, 12:59 AM
I got stuck with a task of updating somebody else?s workbook at work. I have been updating this thing for about a year now, little by little, just adding changes, but one thing always puzzled me. This workbook uses dialog sheets, and pretty redundant coding and the issue is, it leaves behind these unused toolbars that I can find no reference of anywhere in the code. After opening and closing the workbook, go to TOOLS > CUSTOMIZE > TOOLBARS tab, and there is always 2 extra toolbars.
Op1stShiftA
OpEffectiveness
I have no idea where these come from, I delete them, and they reappear. No trace in the code of how they are added, nothing I can find. When I display them and try to activate the code for the toolbar buttons, it seems to try and execute a code from a remote folder. Can't find any links, etc.. not sure what the deal is here? I?ve attached the workbook, and it is a bit to go through, but any ideas are appreciated. I just am very curious to know where these come from.
WARNING* OPENING THIS WORKBOOK DELETES CUSTOM MENU SETTINGS.
I was not aware of this issue when I attached this workbook to the post. I apologize to anyone and everyone for any inconvience you may have encountered, I will not post any more of this developers workbook's without first finding out truly what is involved.
My apologies again.
Op1stShiftA
OpEffectiveness
I have no idea where these come from, I delete them, and they reappear. No trace in the code of how they are added, nothing I can find. When I display them and try to activate the code for the toolbar buttons, it seems to try and execute a code from a remote folder. Can't find any links, etc.. not sure what the deal is here? I?ve attached the workbook, and it is a bit to go through, but any ideas are appreciated. I just am very curious to know where these come from.
WARNING* OPENING THIS WORKBOOK DELETES CUSTOM MENU SETTINGS.
I was not aware of this issue when I attached this workbook to the post. I apologize to anyone and everyone for any inconvience you may have encountered, I will not post any more of this developers workbook's without first finding out truly what is involved.
My apologies again.