hansfranken
New Member
- Joined
- Aug 29, 2002
- Messages
- 3
Hello,
The problem is this: I make a VBA macro and assign it to a shape. When I check the name of the assigned macro it appears as "macroname", which is fine by me. After some time the macro does not start after clicking the shape. The folowing error appears "worksheet.xls" is already opened". When I recheck the name of the assigned macro it appears as "worksheet!macroname". I encounter the same problem when moving a file to a different location. When checking the assigned macro I read "path/worksheet!macroname". How can I avoid all these troubles? What is the big secret behind this name-changing-ability of Excel 2000?
Thanks and byebye
Hans Franken
The Netherlands
The problem is this: I make a VBA macro and assign it to a shape. When I check the name of the assigned macro it appears as "macroname", which is fine by me. After some time the macro does not start after clicking the shape. The folowing error appears "worksheet.xls" is already opened". When I recheck the name of the assigned macro it appears as "worksheet!macroname". I encounter the same problem when moving a file to a different location. When checking the assigned macro I read "path/worksheet!macroname". How can I avoid all these troubles? What is the big secret behind this name-changing-ability of Excel 2000?
Thanks and byebye
Hans Franken
The Netherlands
