how can I have a message displayed when a spreedsheet is opened ?

[dleus]

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.

 

[Gary''s Student]

The the workbook code area, enter this event macro:

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

 

[Gord Dibben]

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