Preventing deletion.
 

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.

--
Big Rick

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

Thsi shoudl help


--
Number_8
------------------------------------------------------------------------
Number_8's Profile: http://www.excelforum.com/member.php...fo&userid=6590
View this thread: http://www.excelforum.com/showthread...hreadid=395248

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

Thanking you in anticipation again.
--
Big Rick


"Number_8" wrote:


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

Thsi shoudl help


--
Number_8
------------------------------------------------------------------------
Number_8's Profile: http://www.excelforum.com/member.php...fo&userid=6590
View this thread: http://www.excelforum.com/showthread...hreadid=395248

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




Big Rick wrote:

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.

--
Big Rick

--

Dave Peterson

The cells might all have a hyperlink to cell A1 in them...

Otherwise are you REALLY sure the sheet is not protected?
It could be protected but with only some cells locked.

BizMark

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


"Dave Peterson" wrote:

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




Big Rick wrote:

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.

--
Big Rick

--

Dave Peterson