If I unprotect and then protect one of the sheets in a workbook, it will
freeze up when I hit the tab key at the last unlocked cell in the row. I
would like to know how I could have a warning message appear whenever I open
the workbook.

The the workbook code area, enter this event macro:

Private Sub Workbook_Open()
MsgBox ("WARNING!! this workbook can lockup!!")
End Sub

--
Gary''s Student - gsnu200786


"dleus" wrote:

If I unprotect and then protect one of the sheets in a workbook, it will
freeze up when I hit the tab key at the last unlocked cell in the row. I
would like to know how I could have a warning message appear whenever I open
the workbook.

I would concentrate more on the "why does it lock up" rather than providing a
warning.

This is not normal behaviour for protected sheets and tabbing to unlocked cells.


Gord Dibben MS Excel MVP

On Sat, 17 May 2008 04:53:00 -0700, dleus
wrote:

If I unprotect and then protect one of the sheets in a workbook, it will
freeze up when I hit the tab key at the last unlocked cell in the row. I
would like to know how I could have a warning message appear whenever I open
the workbook.