I am writing a complex VBA program. I know how to protect a worksheet from
data and format and structure changes, but is there any way to make the user
unable to change the size and screen location of a currently displayed
worksheet? Is there any way to embed a worksheet onto a user form so that it
occupies a certain position on the user form. I desire a situation in which
a "window" on the user form contains a worksheet. Within this "window" the
user can move the cursor in the worksheet and the worksheet's scroll-bars are
displayed and active and the PageUP and PageDown controls work, but the user
can not change any of the data or formatting or structure af the worksheet,
and he cannot change its size or location within the worksheet's "window" on
the user form. In other words, I want something like a list box but I want
to have the formatting and display options (such as text-wrap, color,
co-lwidth, font, etc.) which, as far as I know, are only available on a
worksheet.

Any suggestions as to how to get this would be appreciated.




--
-regards