I'll have a look at it to see what is going on. What version of Excel
are you using. If you have a workbook you can send me, send it to


Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Fri, 19 Dec 2008 12:21:02 -0800, Steven
wrote:

Chip,

I was working with your Form Position file and trying to incorporate it into
something I am doing. I have a file that uses:

Private Sub App_SheetBeforeRightClick .....

so that regardless of what file I am in UserForm1 will show on the
RightClick. If the excel file is a basic file with the cells the default
height and width then the form opens in the position like your file. But if
the file has more going on in it with different row heights and column widths
and word wrap etc... then the form does not open in the consistent spot as
with the standard file.

Is that to be expected or do I need to do more things?

Thank you,

Steven