Preventing deletion.

[Guest]

Hello All
I found a file called "sample" whilst delving about in the program files
folder. On the first sheet only, it is not possible to delete what is in the
cells and when you select any cells, (blank or otherwise) although it shows
with a highlighted colour, when you let go of the mouse the highlight
disapears and defaults to cell A1. The sheet is unprotected.
Please can someone tell me how to do these things.

Thanking you in anticipation.

 

[Number_8]

go to data, validation, enter "" in teh cell value.

Thsi shoudl hel

 

[Guest]

Please can you explain further.
I still cannot solve either problem.

Thanking you in anticipation again.

 

[Dave Peterson]

It sounds to me like it has an event macro running that looks for a selection
change and automatically goes back to A1.

If you rightclick on the worksheet tab and choose View Code, do you see anything
that looks like this:

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
Me.Range("a1").Select
Application.EnableEvents = True
End Sub

 

[Guest]

A thousand thank you's.
I still have not been let down by the help on these pages.