Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm trying ot use following line of code...
ActiveSheet.Shapes(Application.Caller).TopLeftCell .Row ....to generically determine the row in which a button was clicked (which initiates a macro). The code works great for Buttons created with the Forms toolbar, but does not work for Command Buttons created with the Controls Toolbox toolbar (which, I assume is ActiveX). I need to use the latter type so I can also programatically change its BackColor. The error seems to be Error 2023. Any way around this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Caller | Excel Discussion (Misc queries) |