Selecting Only Entire Rows

[dominicwellsuk]

Hi, Is there any way of restricting an Excel user to only selecting entire rows, rather than individual cells?

What I'm ultimately after is allowing the user to only select an entire row, then upon running a macro, the cells within that row are unlocked for individual editing. Running another macro will then return to the original condition of only being able to select entire rows, and individual cells are not editable.

Any ideas?

Thanks.

 

[Sektor]

Something like this:

[COLOR="Blue"]Private[/COLOR] [COLOR="Blue"]Sub[/COLOR] Worksheet_SelectionChange([COLOR="Blue"]ByVal[/COLOR] Target [COLOR="Blue"]As[/COLOR] Range)
    [COLOR="Blue"]If[/COLOR] Target.Address = Rows(Target.Row).Address [COLOR="Blue"]Then[/COLOR]
        MsgBox "You selected full row"
    [COLOR="Blue"]Else[/COLOR]
        MsgBox "Please, select only full row!"
        [COLOR="Green"]' Additional actions here...[/COLOR]
    [COLOR="Blue"]End[/COLOR] [COLOR="Blue"]If[/COLOR]
[COLOR="Blue"]End[/COLOR] [COLOR="Blue"]Sub[/COLOR]

 

[dominicwellsuk]

Thanks, when I try to run this code, assigning Worksheet_SelectionChange to a command button, I get the error:

Compile Error: Argument not Optional

Any ideas?

Thanks.

 

[dominicwellsuk]

Sorry, my mistake, although now I do still get an error: "Sub or Function not Defined"

 

[Sektor]

Put it into worksheet module.

 

[dominicwellsuk]

Done that, but it's still coming up with Argument not Optional. Seems to be based on the (ByVal Target As Range) part of the first line. Sorry, a bit of a newbie at this.

 

[dominicwellsuk]

All working now. My error, sorry. Now I need the alert to work within another Macro.

The user would run a macro to copy a line, it would check that they have copied a full row, rather than just a range, and if it's a full row, continue with the copy macro. If it's not a full row, the alert would show.

Is that easy? Thanks for yuor support.