All I want to show is my user form

[Thespiv]

I have created a user form, and want to retrict access to any other cells in my workbook, I also don't want the user to be able to scroll down the infinate number of rows available below my form PLEASE HELP.

 

[Thespiv]

keeping this on top cos i really need an answer!

 

[Anne Troy]

Use Worksheet protection.

Select the cells you want to ALLOW entry into. Hit Format-Cells, Protection and remove the locked checkbox.
From the Tools menu, choose Protect Worksheet or Workbook.
Check out the help files.

 

[GeorgeB]

To restrict the scroll area use this code.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Me.ScrollArea = "H1:H50" ' change to suit
'To set back to normal use:

Me.ScrollArea = ""

End Sub
This message was edited by GeorgeB on 2002-03-04 11:59