Thanks Ivan,
I understand but is this an if statement and how do you write it?
Marty

"Ivan F Moala" wrote:


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.

Hi Marty
If you know which macro should by run in which sheet, then code it so
it checks the sheet before running. Post back if you require
help.........in coding this ... but give details.


--
Ivan F Moala


------------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...fo&userid=1954
View this thread: http://www.excelforum.com/showthread...hreadid=267852