Disable a LabelClick

[zplugger]

Is it possible to disable a Label1_Click that runs a macro by workbook name.

Please Login or Register  to view this content.

Thanks

[Leith Ross]

Hello Zplugger,

You can set the Labels's Enabled property to False.

[snb]

Please Login or Register  to view this content.

[zplugger]

I guess what I mean is if the workbook is book1 then the label click works,if its a different name it does not.

If ThisWorkbook.Name <> "book1.xlsm" Then
Label1_Click = False
End if

[mikerickson]

Put this in at the start of the Label1_Click routine

Please Login or Register  to view this content.

It sounds like you have a workbook and anticipate someone SaveAs ing the workbook with a different name.
And that you want Label1 in that new workbook to be disabled.

Perhaps you should also write a Workbook_Open routine that looks at the workbook's name and then changes the label to read something besides "Click here for good stuff"

(What if the user desisies to re-name, but not copy Book1.xls?)

[zplugger]

It sounds like you have a workbook and anticipate someone SaveAs ing the workbook with a different name.
And that you want Label1 in that new workbook to be disabled. This is correct because the label controls a invoice number and when
I change the workbook name I don't want the number on the invoice change. If it is change it will mess up my invoice numbers in the
main book.

[zplugger]

O No I forgot to
Thank You guy's for your Help.
Z