Worksheets and Macros

stiffrimpet · Apr 14th, 2002, 07:44 AM

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 · Apr 14th, 2002, 07:55 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 14th, 2002, 07:44 AM	#1
stiffrimpet New Member Join Date: Apr 2002 Posts: 10	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

Apr 14th, 2002, 07:55 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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