ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   No cell-selection in worksheet (https://www.excelbanter.com/excel-programming/365303-no-cell-selection-worksheet.html)

Gert-Jan

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

Gert-Jan



Ardus Petus

No cell-selection in worksheet
 
All worksheets have an ActiveCell

HTH
--
AP

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

Gert-Jan




Bob Phillips

No cell-selection in worksheet
 
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" wrote in message
...
After running a macro I want no selected cell(s) in my sheet. Does someone
know how to do that?

Gert-Jan






All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com