Oct 10 2021 03:35 AM
Oct 10 2021 04:07 AM
If you’re looking to ask a question or start a conversation about Excel, you’re in the right place! Ask away.
Please include your Excel version, sample file, and a bit of context to help others answer your question:
More infos in the upper Link.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
Oct 10 2021 05:04 AM
@Lizzy_G Perhaps this code in the worksheet is what you mean:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, cancel As Boolean) ActiveCell.Value = Chr(195) End Sub
Double click on a cell in the sheet where this code resides and it will come out like this:
Oct 10 2021 07:49 AM
@Lizzy_G I was not clear. Sorry. The code need to be entered into a cell. It need to go into the "code for for the worksheet you are working in".
Right-click on the sheet tab and select "View code"
This will open the Visual Basic editor.
Then, copy the code like in the picture below:
Now save the workbook, macro-enables (I.e. xlsm)
I've attached such a workbook, so that you see how it should look like.
The above screenshots were made on a Mac, bit it's similar on a PC.