Need help with Button command

Oh my god! Please don't think I will understand what you said. It is quite complicated for me what you said. It is better for me to understand if you explain just like xld did. Is that right DoubleClick is command type which need to be write as code?

I am suggesting to substitute this for the first line of the routine

Code:

---

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Excel.Range, Cancel As Boolean)

---

Then the routine would be triggered by double-clicking rather than single clicking on a cell.

Can you please read my comment again? See above before mikerickson's comment. Thanks mikerickson for some help. I will try.

Hey xld, I understood yours latest code. Is it possible to find user info only from sheet1. How to combine all codes together into one file. Sometimes I have to find user info for all sheets sometimes for one sheet. There should options button so that i can click whatever i like to choose. Hopefully you should understand.