View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Embedding spreadsheet in a user form


You may want to start over with a new post.
I would not have attempted to answer your question if you had mentioned XL2007.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"GeorgeJ"
wrote in message
Thank you Jim. I was unaware that one could add more types of controls by
right clicking the control box. However, I was *not* able to find the one
you referred to, specifically "Microsoft Office Spreadsheet xx.o". When I
right clicked in the control box there appeared a drop down list of
additional possible controls. They were arranged alphabetically and the
only ones starting with "Microsoft Office" were of the form "Microsoft Office
Outlook ...". I didn't see any additional controls that contained the word
"spreadsheet". I am using Excel 2007.

I would like to resubmitt my original question. Is it possible to lock a
worksheet so that

a) the user cannot move the cursor outside of a certain row range and a
certain column range ?

b) the use cannot change the location on the screen of the window displaying
the worksheet, and he cannot change the size of the window displaying the
worksheet?

Thanks