Hi,
I am using the following in a Worksheet, to prevent the user from using the
fill handle on that particular sheet:

Private Sub Worksheet_Activate()
Application.CellDragAndDrop = False
End Sub

Private Sub Worksheet_Deactivate()
Application.CellDragAndDrop = True
End Sub

However, if the workbook is saved with this sheet active, closed, then
opened, the macro doesn't fire. How can I prevent this from occurring?

Regards - Dave.