The code €˜Application.DisplayAlerts = False does not work in all instances.

I have two virtually identical worksheets in different workbooks.

These worksheets act as an index and each cell is protected. By
double-clicking on a particular cell my VBA code gathers some data and
completes a procedure. The €˜Application.DisplayAlerts = False should
prevent the protection alert from appearing.

In the first workbook it works. The code was placed in €˜Private Sub
Worksheet_Activate(). It did not work if it was placed at the beginning of
code in €˜Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range,
Cancel As Boolean).

Place the same code in the second workbook and it does not work.

I have also opened a new workbook. Sheet1 has been protected and the
€˜Application.DisplayAlerts = False code placed in €˜Private Sub
Worksheet_Activate(). If I DoubleClick the protect alert appears.

Is there a way around this problem?

The only thing that has changed since the first book was created is that
Vista Business Version 6.0.6002 Service Pack 2 Build 6002 has been installed.

Excel version used is Excel 2003.

--
Derek Dowle