ExcelBanter - No active cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - No active cell (https://www.excelbanter.com/excel-programming/342742-no-active-cell.html)

Harley

No active cell

Is it possible to open a workbook, through code, with no active cell? If it
is possible, please post an example.

Thank you

Jim Thomlinson[_4_]

No active cell

Nope... Death, Taxes and an active cell. All things you can count on...
--
HTH...

Jim Thomlinson

"Harley" wrote:

Is it possible to open a workbook, through code, with no active cell? If it
is possible, please post an example.

Thank you

Vic Eldridge[_3_]

No active cell

Hi Harley,

The following might suit your requirements. There's still an activecell,
it's just not highlighted.

With ActiveSheet
.EnableSelection = xlNoSelection
.Protect
End With

Regards,
Vic Eldridge

"Harley" wrote:

Is it possible to open a workbook, through code, with no active cell? If it
is possible, please post an example.

Thank you

All times are GMT +1. The time now is 06:58 AM.