protected cells can be deleted?!
 

I have a protect macro that runs whenever the workbook is opened and this
works well whenever a user attempts to overwrite a locked cell. However, if
the user just selects a locked cell then hits the delete key the cell is
deleted!

My macro is as follows:

Sub Auto_Open()

Dim wks As Worksheet

For Each wks In Worksheets
With wks
.Protect Password:="Password", userinterfaceonly:=True
.EnableOutlining = True
End With
Next wks

ActiveWorkbook.Protect Password:="Password", Structu=True, Windows:=False

End Sub

Any ideas how I can stop locked cells being deleted?

Thanks so much in advance!

protected cells can be deleted?!
 

Are you sure that the cell that they're clearing is locked.

You have to lock the cell (format|cells|protection tab), then protect the
worksheet (tools|protection|protect sheet) to stop what you're seeing.

I'd double check that locked status if I were you.

DannyS wrote:

I have a protect macro that runs whenever the workbook is opened and this
works well whenever a user attempts to overwrite a locked cell. However, if
the user just selects a locked cell then hits the delete key the cell is
deleted!

My macro is as follows:

Sub Auto_Open()

Dim wks As Worksheet

For Each wks In Worksheets
With wks
.Protect Password:="Password", userinterfaceonly:=True
.EnableOutlining = True
End With
Next wks

ActiveWorkbook.Protect Password:="Password", Structu=True, Windows:=False

End Sub

Any ideas how I can stop locked cells being deleted?

Thanks so much in advance!

--

Dave Peterson

protected cells can be deleted?!
 

Yes, I am certain. I can be sure as when I try to type in the cell I get the
standard 'This cell is locked and protected' pop up.

"Dave Peterson" wrote:

Are you sure that the cell that they're clearing is locked.

You have to lock the cell (format|cells|protection tab), then protect the
worksheet (tools|protection|protect sheet) to stop what you're seeing.

I'd double check that locked status if I were you.

DannyS wrote:

I have a protect macro that runs whenever the workbook is opened and this
works well whenever a user attempts to overwrite a locked cell. However, if
the user just selects a locked cell then hits the delete key the cell is
deleted!

My macro is as follows:

Sub Auto_Open()

Dim wks As Worksheet

For Each wks In Worksheets
With wks
.Protect Password:="Password", userinterfaceonly:=True
.EnableOutlining = True
End With
Next wks

ActiveWorkbook.Protect Password:="Password", Structu=True, Windows:=False

End Sub

Any ideas how I can stop locked cells being deleted?

Thanks so much in advance!

--

Dave Peterson

protected cells can be deleted?!
 

Since you've double checked the lockedness of the cell, the only thing that I
can think of is that maybe there's a macro that's stolen the delete key.

The delete key now executes a macro and with "userinterfaceonly:=True", it can
do pretty much what it wants.

One more guess...

Is this cell merged with other cells?

DannyS wrote:

Yes, I am certain. I can be sure as when I try to type in the cell I get the
standard 'This cell is locked and protected' pop up.

"Dave Peterson" wrote:

Are you sure that the cell that they're clearing is locked.

You have to lock the cell (format|cells|protection tab), then protect the
worksheet (tools|protection|protect sheet) to stop what you're seeing.

I'd double check that locked status if I were you.

DannyS wrote:

I have a protect macro that runs whenever the workbook is opened and this
works well whenever a user attempts to overwrite a locked cell. However, if
the user just selects a locked cell then hits the delete key the cell is
deleted!

My macro is as follows:

Sub Auto_Open()

Dim wks As Worksheet

For Each wks In Worksheets
With wks
.Protect Password:="Password", userinterfaceonly:=True
.EnableOutlining = True
End With
Next wks

ActiveWorkbook.Protect Password:="Password", Structu=True, Windows:=False

End Sub

Any ideas how I can stop locked cells being deleted?

Thanks so much in advance!

--

Dave Peterson


--

Dave Peterson

protected cells can be deleted?!
 

Nope, no merged cells. It is not one cell, it is all (locked) cells.

I think I need the userinterfaceonly=true line as I have a number of grouped
and outlined rows that the user needs to maximise and minimise.

"Dave Peterson" wrote:

Since you've double checked the lockedness of the cell, the only thing that I
can think of is that maybe there's a macro that's stolen the delete key.

The delete key now executes a macro and with "userinterfaceonly:=True", it can
do pretty much what it wants.

One more guess...

Is this cell merged with other cells?

DannyS wrote:

Yes, I am certain. I can be sure as when I try to type in the cell I get the
standard 'This cell is locked and protected' pop up.

"Dave Peterson" wrote:

Are you sure that the cell that they're clearing is locked.

You have to lock the cell (format|cells|protection tab), then protect the
worksheet (tools|protection|protect sheet) to stop what you're seeing.

I'd double check that locked status if I were you.

DannyS wrote:

I have a protect macro that runs whenever the workbook is opened and this
works well whenever a user attempts to overwrite a locked cell. However, if
the user just selects a locked cell then hits the delete key the cell is
deleted!

My macro is as follows:

Sub Auto_Open()

Dim wks As Worksheet

For Each wks In Worksheets
With wks
.Protect Password:="Password", userinterfaceonly:=True
.EnableOutlining = True
End With
Next wks

ActiveWorkbook.Protect Password:="Password", Structu=True, Windows:=False

End Sub

Any ideas how I can stop locked cells being deleted?

Thanks so much in advance!

--

Dave Peterson


--

Dave Peterson

protected cells can be deleted?!
 

Any macro that steals the delete key?

DannyS wrote:

Nope, no merged cells. It is not one cell, it is all (locked) cells.

I think I need the userinterfaceonly=true line as I have a number of grouped
and outlined rows that the user needs to maximise and minimise.

"Dave Peterson" wrote:

Since you've double checked the lockedness of the cell, the only thing that I
can think of is that maybe there's a macro that's stolen the delete key.

The delete key now executes a macro and with "userinterfaceonly:=True", it can
do pretty much what it wants.

One more guess...

Is this cell merged with other cells?

DannyS wrote:

Yes, I am certain. I can be sure as when I try to type in the cell I get the
standard 'This cell is locked and protected' pop up.

"Dave Peterson" wrote:

Are you sure that the cell that they're clearing is locked.

You have to lock the cell (format|cells|protection tab), then protect the
worksheet (tools|protection|protect sheet) to stop what you're seeing.

I'd double check that locked status if I were you.

DannyS wrote:

I have a protect macro that runs whenever the workbook is opened and this
works well whenever a user attempts to overwrite a locked cell. However, if
the user just selects a locked cell then hits the delete key the cell is
deleted!

My macro is as follows:

Sub Auto_Open()

Dim wks As Worksheet

For Each wks In Worksheets
With wks
.Protect Password:="Password", userinterfaceonly:=True
.EnableOutlining = True
End With
Next wks

ActiveWorkbook.Protect Password:="Password", Structu=True, Windows:=False

End Sub

Any ideas how I can stop locked cells being deleted?

Thanks so much in advance!

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

protected cells can be deleted?!
 

Nope.

I think it might be a bug?

"Dave Peterson" wrote:

Any macro that steals the delete key?

DannyS wrote:

Nope, no merged cells. It is not one cell, it is all (locked) cells.

I think I need the userinterfaceonly=true line as I have a number of grouped
and outlined rows that the user needs to maximise and minimise.

"Dave Peterson" wrote:

Since you've double checked the lockedness of the cell, the only thing that I
can think of is that maybe there's a macro that's stolen the delete key.

The delete key now executes a macro and with "userinterfaceonly:=True", it can
do pretty much what it wants.

One more guess...

Is this cell merged with other cells?

DannyS wrote:

Yes, I am certain. I can be sure as when I try to type in the cell I get the
standard 'This cell is locked and protected' pop up.

"Dave Peterson" wrote:

Are you sure that the cell that they're clearing is locked.

You have to lock the cell (format|cells|protection tab), then protect the
worksheet (tools|protection|protect sheet) to stop what you're seeing.

I'd double check that locked status if I were you.

DannyS wrote:

I have a protect macro that runs whenever the workbook is opened and this
works well whenever a user attempts to overwrite a locked cell. However, if
the user just selects a locked cell then hits the delete key the cell is
deleted!

My macro is as follows:

Sub Auto_Open()

Dim wks As Worksheet

For Each wks In Worksheets
With wks
.Protect Password:="Password", userinterfaceonly:=True
.EnableOutlining = True
End With
Next wks

ActiveWorkbook.Protect Password:="Password", Structu=True, Windows:=False

End Sub

Any ideas how I can stop locked cells being deleted?

Thanks so much in advance!

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

protected cells can be deleted?!
 

It could still be a macro--you haven't commented on that.

But...

If you create a new workbook and set it up the same way, do you have the same
results?

If you create a new worksheet in the same workbook and test it, do you have the
same results?

If you open excel in safe mode:

Close excel
windows start button|run
excel /safe
file|open your workbook
and test it out, does it work ok?

Opening excel in safe mode will disable macros.


DannyS wrote:

Nope.

I think it might be a bug?

"Dave Peterson" wrote:

Any macro that steals the delete key?

DannyS wrote:

Nope, no merged cells. It is not one cell, it is all (locked) cells.

I think I need the userinterfaceonly=true line as I have a number of grouped
and outlined rows that the user needs to maximise and minimise.

"Dave Peterson" wrote:

Since you've double checked the lockedness of the cell, the only thing that I
can think of is that maybe there's a macro that's stolen the delete key.

The delete key now executes a macro and with "userinterfaceonly:=True", it can
do pretty much what it wants.

One more guess...

Is this cell merged with other cells?

DannyS wrote:

Yes, I am certain. I can be sure as when I try to type in the cell I get the
standard 'This cell is locked and protected' pop up.

"Dave Peterson" wrote:

Are you sure that the cell that they're clearing is locked.

You have to lock the cell (format|cells|protection tab), then protect the
worksheet (tools|protection|protect sheet) to stop what you're seeing.

I'd double check that locked status if I were you.

DannyS wrote:

I have a protect macro that runs whenever the workbook is opened and this
works well whenever a user attempts to overwrite a locked cell. However, if
the user just selects a locked cell then hits the delete key the cell is
deleted!

My macro is as follows:

Sub Auto_Open()

Dim wks As Worksheet

For Each wks In Worksheets
With wks
.Protect Password:="Password", userinterfaceonly:=True
.EnableOutlining = True
End With
Next wks

ActiveWorkbook.Protect Password:="Password", Structu=True, Windows:=False

End Sub

Any ideas how I can stop locked cells being deleted?

Thanks so much in advance!

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson