Email addresss

[howard]

I have email addresses in Col M on Sheet2

From time to time I need to edit these and if I click in the cell outlook is activated

I get remove the hyperlink to allow editing , but I would like code that can be posted in the sheet that will allow the email address to be edited without activating outlook. The email addresses are linked to VBA so that I can email selected ranges on my workbook


Your assistance in this regard is most appreciated

 

[Andrew Poulsom]

Use right click to edit it. Or select the cell with the keyboard rather than the mouse.

 

[howard]

thanks for your input

 

[Michael M]

Or just left click and hold the mouse on the cell for a few seconds and edit in the formula bar !!

 

[howard]

Thanks Michael