When I Double Click on Cell Erase Text in the Cell , in the PROTECTED SHEET

**soubasa** · 04-16-2020, 03:07 PM

Hello, When I Double Click on Cell Erase Text in the Cell , in the PROTECTED SHEET, I need to deactivate it.

Could You please help me ?

**alansidman** · 04-16-2020, 03:25 PM

In the worksheet Before Double Click event in the VBE place this code

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
ActiveCell.ClearContents
End Sub

Save your file as either .xlsb or .xlsm

**soubasa** · 04-16-2020, 03:46 PM

I'm not a use VBA , just use a simple table .xlsx

it solved by ---> Option ---> Advanced ---> then uncheck Allow editing directly in cells

Sincerely Thanks

When I Double Click on Cell Erase Text in the Cell , in the PROTECTED SHEET

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

When I Double Click on Cell Erase Text in the Cell , in the PROTECTED SHEET

Re: When I Double Click on Cell Erase Text in the Cell , in the PROTECTED SHEET

Re: When I Double Click on Cell Erase Text in the Cell , in the PROTECTED SHEET

Thread Information

Users Browsing this Thread

Similar Threads

double-click to display / hide text in a cell

Double click cell - copy data to new sheet - create a list from double clicking

[SOLVED] Before double click event with if statements (Double clicking blank cell stops bdc firing)

Changing cell properties with double click, then revert with another double click

Copy double-clicked cell to next empty row in different sheet with each double-click

Double click a cell, see a Pop up box, Enter Text, Box goes away when leave cell

[SOLVED] Click on graph bar to execute a double-click in a pivot table cell

Bookmarks

Bookmarks

Posting Permissions