Hi I have inserted the following code to open a userform when a blank cell is clicked. This works fine but what i need it to do is make it only open the userform when any of the Column A Cells A20:A174 are clicked. Is it also possible to make the user have to double click the cell to open the userform and disable the right mouse click
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target = "" Then Menu.Show End Sub
Bookmarks