Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel file deletion | Excel Discussion (Misc queries) | |||
preventing duplicates | Excel Worksheet Functions | |||
Preventing Viewing of certain columns by recipient | Excel Discussion (Misc queries) | |||
Preventing cell contents from printing | Excel Discussion (Misc queries) | |||
Preventing Duplicate Entries in rows | Excel Worksheet Functions |