Kim

If you embed a button directly on the sheet, you can set its properties such
that it will not move or stretch regardless of what people do to the rows &
columns.

Right cluck on the button Format Control Properties "Don't move or
size with cells".


--
Time is just the thing that keeps everything from happening all at once


"KIM W" wrote:

How can I most simply have user display a userform with the following
requirements:
1. I don't want them to have to learn and remember keyboard shortcut
2. Clicking on worksheet is desirable solution
3. User may rearrange and add columns
4. User may change width of columns
5. Userform is relevant to only SOME columns, so if it were a button it
would only be on 10% of the columns in a many column worksheet (not designed
to print)
6. Same userForm is launced regardless of column one is working in.
7. BTW, this UserForm ends up writing text into the active cell.

Thanks in advance.