Preventing deletion.

[Big Rick]

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

[Number_8]

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

Thsi shoudl help

[Big Rick]

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
>
>

[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




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

[BizMark]

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


--
BizMark

[Big Rick]

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
>