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

D

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.
 
G

Gary''s Student

The the workbook code area, enter this event macro:

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

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
 
Top