View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default Cell Indicator Problem

Hi,
Right click that worksheet's sheet tab then select "View code".
This takes you to the VBA Editor.
In the VBA Editor go ViewProperties window.
In the lefthand column of that worksheet's Properties window find and
select "EnableSelection". In the righthand column on the same line
click on the dropdown arrow and select "-4142 - xlNoSelection".
Press Alt + F11 to return to the worksheet and you should have the
desired result.

Ken Johnson