Hi all ; sorry to keep going on, then again it's all good traffic.

I have some code on a custom button, on a custom toolbar, to display a UserForm with the 3rd tab of its multipage to the fore (MultiPage1.Value = 2).

The user will be told that this button only applies when the active sheet is called whatever AND row > 2 and column = 5 or 6 AND cell <> "".

Obviously I can write these conditions in 1 by 1, to stop the form displaying, e.g.

If ActiveSheet.Name <> "Whatever" then Exit Sub
If ActiveCell.Row < 3 Then Exit Sub
, etc., etc., thus nothing happens. But I want to then show a MsgBox ("Selection out of range" or something) so that the user doesn't just forget and/or assume the button has stopped working.

So far I have the following:

Sub Test()
On Error GoTo WrongRange
If ActiveCell.Row < 3 Then Exit Sub 'for example
frmQuote.MultiPage1.Value = 2
frmQuote.Show
Exit Sub
WrongRange:
MsgBox "Active cell must be in row 3."
End Sub
This is adapted from a book by a VERY famous author and, err, & it's not working. So I must be missing something. BTW, "Break on Unhandled Errors" is ON.

TIA,
Andy