| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
assign excel 2003 macro with parms to shape
I have different shapes with one common macro. I would like to know which
shape name was used to envoke the macro. Any ideas would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
assign excel 2003 macro with parms to shape
hi, Marvin !
I have different shapes with one common macro. I would like to know which shape name was used to envoke the macro. Any ideas would be greatly appreciated. depending on the figure type... did you already attempt with Application.Caller ? hth, hector. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
assign excel 2003 macro with parms to shape
Héctor,
I was going to suggest that, but initial tests from the routine showed: ? TypeName(Application.Caller) Range which was a bit confusing. Now it works, showing: ? TypeName(Application.Caller), Application.Caller String Rectangle 3 Can't repeat the error now, so who knows... NickHK "Héctor Miguel" wrote in message ... hi, Marvin ! I have different shapes with one common macro. I would like to know which shape name was used to envoke the macro. Any ideas would be greatly appreciated. depending on the figure type... did you already attempt with Application.Caller ? hth, hector. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - assign macro to custom toolbar button | Excel Discussion (Misc queries) | |||
| how do you assign a macro to a command button in Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I assign a macro to a command button in excel, office 2003 | Excel Discussion (Misc queries) | |||
| Passing parms to a VBS file or a macro when executed? | Excel Programming | |||
| Assign macro to button in EXCEL 2003 | Excel Programming | |||
Linear Mode
