Include a line in your code which checks that the required worksheet is
selected before the macro continues.

"Marty" wrote in message
...
Workbook contains serveral worksheets with a number of macros. If the
wrong
macro is executed for a given worksheet it will ruin the integrity of the
worksheet.
How do I avoid this problem other than using passwords.