View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default how can I have a message displayed when a spreedsheet is opened ?

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.