I've got a small picture on Row 1 in my worksheet.

Can it be used to fire an event? I notice a single click
selects handles around it - and d-click brings up the Format
window. Can these be disabled ?

Thanks - Kirk

That's because a single click selects the picture. If you rightclick on this
picture, you can select Assign Macro, and use it as a command button yes.
That is, if you have a macro that you want to "fire" using this picture as a
button.

--
HTH

Kassie

Replace xxx with hotmail


"kirkm" wrote:

>
> I've got a small picture on Row 1 in my worksheet.
>
> Can it be used to fire an event? I notice a single click
> selects handles around it - and d-click brings up the Format
> window. Can these be disabled ?
>
> Thanks - Kirk
>

On Tue, 5 May 2009 23:19:01 -0700, Kassie <(E-Mail Removed)>
wrote:

>That's because a single click selects the picture. If you rightclick on this
>picture, you can select Assign Macro, and use it as a command button yes.
>That is, if you have a macro that you want to "fire" using this picture as a
>button.

Thanks Kassie, that's exactly it. I'm setting it up now but
have struck a snag - I want to call the macro from 2 different sheets
and have the macro detect the name of the worksheet that called it.

Googling around but seem to find everything but. Do you know?

Thanks - Kirk

Exactly what do you mean by "detecting"?
If your macro refers to the active sheet, then whichever sheet "calls" it,
is still the active sheet.
If you tell us what your goal is, then maybe we can offer better assistance

--
HTH

Kassie

Replace xxx with hotmail


"kirkm" wrote:

> On Tue, 5 May 2009 23:19:01 -0700, Kassie <(E-Mail Removed)>
> wrote:
>
> >That's because a single click selects the picture. If you rightclick on this
> >picture, you can select Assign Macro, and use it as a command button yes.
> >That is, if you have a macro that you want to "fire" using this picture as a
> >button.
>
> Thanks Kassie, that's exactly it. I'm setting it up now but
> have struck a snag - I want to call the macro from 2 different sheets
> and have the macro detect the name of the worksheet that called it.
>
> Googling around but seem to find everything but. Do you know?
>
> Thanks - Kirk
>

Just to clarify Kassie's response to you (in case this is all new to you),
there is an ActiveSheet object (with all the properties of a Sheet object)
that is set to the sheet that is currently active when the code is
executing. So, to get your active sheet's name, try something like this...

WhoCalledMe = ActiveSheet.Name

or this...

If ActiveSheet.Name = "Sheet1" Then

or any of a number of different ways.

Note that in the above If..Then statement, the logical test is case
sensitive.

--
Rick (MVP - Excel)


"Kassie" <(E-Mail Removed)> wrote in message
news:3DD1D93B-5A28-48CE-9C1F-(E-Mail Removed)...
> Exactly what do you mean by "detecting"?
> If your macro refers to the active sheet, then whichever sheet "calls" it,
> is still the active sheet.
> If you tell us what your goal is, then maybe we can offer better
> assistance
>
> --
> HTH
>
> Kassie
>
> Replace xxx with hotmail
>
>
> "kirkm" wrote:
>
>> On Tue, 5 May 2009 23:19:01 -0700, Kassie <(E-Mail Removed)>
>> wrote:
>>
>> >That's because a single click selects the picture. If you rightclick on
>> >this
>> >picture, you can select Assign Macro, and use it as a command button
>> >yes.
>> >That is, if you have a macro that you want to "fire" using this picture
>> >as a
>> >button.
>>
>> Thanks Kassie, that's exactly it. I'm setting it up now but
>> have struck a snag - I want to call the macro from 2 different sheets
>> and have the macro detect the name of the worksheet that called it.
>>
>> Googling around but seem to find everything but. Do you know?
>>
>> Thanks - Kirk
>>

On Wed, 6 May 2009 09:14:09 -0700, Kassie <(E-Mail Removed)>
wrote:

>Exactly what do you mean by "detecting"?
>If your macro refers to the active sheet, then whichever sheet "calls" it,
>is still the active sheet.
>If you tell us what your goal is, then maybe we can offer better assistance

I did !! ActiveSheet was it.

Thanks - Kirk

On Wed, 6 May 2009 12:46:44 -0400, "Rick Rothstein"
<(E-Mail Removed)> wrote:

>Just to clarify Kassie's response to you (in case this is all new to you),
>there is an ActiveSheet object (with all the properties of a Sheet object)
>that is set to the sheet that is currently active when the code is
>executing. So, to get your active sheet's name, try something like this...
>
>WhoCalledMe = ActiveSheet.Name
>
>or this...
>
>If ActiveSheet.Name = "Sheet1" Then
>
>or any of a number of different ways.
>
>Note that in the above If..Then statement, the logical test is case
>sensitive.

Thanks Rick... I'm still finding out about objects, properties etc
etc
ActiveSheet.Name solved everything. Now I want ActiveSheet.CurrentRow
but, well, you know - it ain't there! I left a new question on that.
Cheers - Kirk