Thanks Bigwheel,
I am rather new at this and understand your answere but have no idea how to
write it . Can you help?
Thanks again
Marty

"bigwheel" wrote:

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.