Prev: How to make weekly totals change as the days in the week change ye
Next: Making my App only work so many times
From: Ken Warthen on 19 Mar 2010 15:50
I have a customer ribbon in an Excel 2007 workbook. I would like to enable a
button on the ribbon if a specific worksheet is active, disabled if any other
worksheet is active. I'm not quite sure how to write the code in the
onGetEnabled event. If anyone has experience with this, I'd be very
appreciative for any help.

TIA,

Ken
From: JLGWhiz on 19 Mar 2010 16:17
Here is some psuedo code to give you an idea.

If ActiveSheet.Name = Worksheets("CertainWorksheet").Name Then
'Code to enable the button
Else
,Button.Enabled = False
End If



"Ken Warthen" <KenWarthen(a)discussions.microsoft.com> wrote in message
news:D1A59326-9BE8-490D-A221-6ACD5DC301A9(a)microsoft.com...
>I have a customer ribbon in an Excel 2007 workbook. I would like to enable
>a
> button on the ribbon if a specific worksheet is active, disabled if any
> other
> worksheet is active. I'm not quite sure how to write the code in the
> onGetEnabled event. If anyone has experience with this, I'd be very
> appreciative for any help.
>
> TIA,
>
> Ken


 | 
Pages: 1
Prev: How to make weekly totals change as the days in the week change ye
Next: Making my App only work so many times