ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Change Excel Settings (https://www.excelbanter.com/excel-discussion-misc-queries/3451-change-excel-settings.html)

Ronbo

Change Excel Settings
 
How does one remove the highlight of a cell when it is clicked on and remove
the right click dialog box?

Gord Dibben

Ronbo

AFAIK first item cannot be done, although you could lock all cells and not
allow locked cells to be selected(if using xl2002 or 2003).

Second item requires VBA

Application.CommandBars("Cell").Enabled = False


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 10:09:02 -0800, "Ronbo"
wrote:

How does one remove the highlight of a cell when it is clicked on and remove
the right click dialog box?




All times are GMT +1. The time now is 08:35 PM.

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