Alerts disabled in DoEvents loop - Deletion of protected-locked ce

  • Thread starter Thread starter Potter
  • Start date Start date
P

Potter

When running a macro that includes a loop with DoEvents alert messages are
not shown to the user. In my case locked cells of protected Worksheets do
not allow data entry but do not alert the user as to why. Even more
problematic the content of these protected cells are delete when the delete
key is pressed! This does not occur if the macro is not running. Instead an
alert dialog is displayed and the action is cancelled.

The problem can be reproduced with the following steps:
1. Create a Workbook and set all cells in a Worksheet to locked
2. Enter values into some of the cells
3. Protect the Worksheet
4. Select a cell and press delete (alert message should be shown)
5. Run a macro with a doevents loop
6. While the loop is running select a cell and press delete (contents are
removed and no alert is shown!)

example macro (runs a doevents loop for 2 minutes):
Sub executeDoEvents()
Application.DisplayAlerts = True
For i = 1 To 1200
Sleep (100)
DoEvents
Next i


MsgBox "Done executing DoEvents"

End Sub
 
Potter said:
The problem can be reproduced with the following steps:
1. Create a Workbook and set all cells in a Worksheet to locked
Click to expand...

They should all be locked by default.
2. Enter values into some of the cells
3. Protect the Worksheet
4. Select a cell and press delete (alert message should be shown)
Confirmed.

5. Run a macro with a doevents loop
6. While the loop is running select a cell and press delete (contents are
removed and no alert is shown!)
Click to expand...

Not on my machine. There's no message displayed, but cells contents
aren't deleted either.
 
Thanks for the feedback. It would be a big step forward to get the behavior
you see.

I'm using Excel 2003 (11.8.142.8132) SP2

What version of Excel did you try this with?
 
The deletion behavior appear to be tied to macro security. With security set
to 'Low' Excel allows deletion of protected-locked cells (while in DoEvents
loop). With 'Medium' security this is not the case (although no alert is
displayed). It appears that user actions that are processed during the
DoEvents loop are executed using the security rights of the macro. Is there
any way around this?
 
Potter said:
Thanks for the feedback.  It would be a big step forward to get the
behavior you see.

I'm using Excel 2003 (11.8.142.8132) SP2

What version of Excel did you try this with?
Click to expand...
....

Excel 2003 SP1
 
Harlan Grove said:
Not on my machine. There's no message displayed, but cells contents
aren't deleted either.
Click to expand...
No they wouldn't dare Harlan <G>

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top