If a Command Button is activated to run a macro and if any of the rows 1 through 7 are active, do not run macro…..but show message box advising that this is the case. Message Box to have a button having caption “ok” which will return control back to user. If neither of the rows 1 through 7 are the Active Row, run the macro.