Worksheets and Macros

[stiffrimpet]

Is there any way to make a Macro only relevant to one worksheet? Ie. the macro will only work when the user is on that worksheet.

Cheers

s=t=i=f=f=r=i=m=p=e=t

 

[dk]

Hi,

You could try something like this:-

If ActiveSheet.Name <> "YourSheetName" Then Exit Sub

Where you'll need to substitute YourSheetName with the name of your worksheet.

HTH,
Dan