No cell-selection in worksheet

[Gert-Jan]

After running a macro I want no selected cell(s) in my sheet. Does someone
know how to do that?

Gert-Jan

[Ardus Petus]

All worksheets have an ActiveCell

HTH
--
AP

"Gert-Jan" <[email protected]> a écrit dans le message de news:
[email protected]...
> After running a macro I want no selected cell(s) in my sheet. Does someone
> know how to do that?
>
> Gert-Jan
>

[Bob Phillips]

Not possible. At least one cell must be selected.

You could remove the focus and move it to a hidden shape, which might
achieve your objective

With ActiveSheet.Shapes("Rectangle 1")
.Visible = True
.Select
.Visible = False
End With

But why would you need to do it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gert-Jan" <[email protected]> wrote in message
news:[email protected]...
> After running a macro I want no selected cell(s) in my sheet. Does someone
> know how to do that?
>
> Gert-Jan
>
>