Thank you very much for this. This works well.

sincerely

Jeff Smith


"Bill Manville" wrote in message
...
Jeff Smith wrote:
I was wondering if I could insert - at the start of each macro , prior
to
the controlled actions, something like....

If Main!D12 = "Unauthorised User" End Sub


If Sheets("Main").Range("D12") = "Unauthorised User" Then Exit Sub

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup