Stop macro if not in correct workseet

[Patti]

A user will have a macro attached to a tool bar button. How can I ensure
that if they user is not in workbook "MyWorkbook" and not on sheet
"MyWorksheet" that the macro will not execute, instead giving MsgBox ("You
are not in the correct file")

Thanks in advance.

Patti

 

[Frank Kabel]

Hi
try something like
IF activeworkbook.name = "your workbookname" and _
activesheet.name = "your_worksheet_name" then
' continue
else
msgbox "Wrong workbook/worksheet"
exit sub
end if

 

[Patti]

That's perfect Frank. Thank you.

Patti

Hi
try something like
IF activeworkbook.name = "your workbookname" and _
activesheet.name = "your_worksheet_name" then
' continue
else
msgbox "Wrong workbook/worksheet"
exit sub
end if