ProblemFinder
New Member
- Joined
- Aug 22, 2011
- Messages
- 10
Hi,
I am trying to use a macro written by someone in my department. It's basic function is to pull up a schematic from another program based on the number in the selected cell (e.g. 167722A). All that should be required on my part is to paste the Add-In in the Office 11/XLSTART folder.
The problem is that I am getting an error when I try to run the macro: "The macro 'xlDrawingUtils.xla!ThisWorkbook.DisplayDrawing' cannot be found." I know the add-in is in the right folder because the macro shows up on the toolbar. I am running Excel 2003 on Windows XP SP3.
Some of the things I've tried so far:
-Macro security is on medium. I've changed it to low, doesn't make a difference.
-The macro does not show up in the Alt+F8 macro list, but it doesn't on the computers where it works either. Is this because it's a prive macro?
-I've checked the Error Trapping settings in the General tab of the VB Editor Options. They are set to "Break on Unhandled Errors", changing this has no effect.
-I've also checked the References in the VB Editor, they are the same for both versions (working and not).
I've uploaded the Add-In file here: http://ge.tt/9ht2b27?c
Not sure where to go from here, any help would be appreciated.
Note: For you, a working macro would be one where running it does not generate the error, since you don't have access to the application where the schematic is pulled from.
Thanks.
I am trying to use a macro written by someone in my department. It's basic function is to pull up a schematic from another program based on the number in the selected cell (e.g. 167722A). All that should be required on my part is to paste the Add-In in the Office 11/XLSTART folder.
The problem is that I am getting an error when I try to run the macro: "The macro 'xlDrawingUtils.xla!ThisWorkbook.DisplayDrawing' cannot be found." I know the add-in is in the right folder because the macro shows up on the toolbar. I am running Excel 2003 on Windows XP SP3.
Some of the things I've tried so far:
-Macro security is on medium. I've changed it to low, doesn't make a difference.
-The macro does not show up in the Alt+F8 macro list, but it doesn't on the computers where it works either. Is this because it's a prive macro?
-I've checked the Error Trapping settings in the General tab of the VB Editor Options. They are set to "Break on Unhandled Errors", changing this has no effect.
-I've also checked the References in the VB Editor, they are the same for both versions (working and not).
I've uploaded the Add-In file here: http://ge.tt/9ht2b27?c
Not sure where to go from here, any help would be appreciated.
Note: For you, a working macro would be one where running it does not generate the error, since you don't have access to the application where the schematic is pulled from.
Thanks.
