You can set up the macro to stop and display a message box if it is ru
with the active workbook being "MASTER".
Sub Test()
If ActiveWorkbook.Name = "MASTER" Then
YesNo = MsgBox("Do you want to run on the MASTER workbook?", vbYesNo)
If YesNo = vbNo Then
MsgBox "Please activate the correct workbook."
Exit Sub
End If
End If
'Your code here
End Sub
This isn't exactly what you asked for, sorry for that, but it might a
least be a temporary fix.
-Ikaabo
--
Ikaabo
-----------------------------------------------------------------------
Ikaabod's Profile:
http://www.excelforum.com/member.php...fo&userid=3337
View this thread:
http://www.excelforum.com/showthread.php?threadid=53596