Userform Entry only?

[saprater]

Does anyone know if we can restrict entry to a worksheet thru a userform only?

I think it can be done through protect unprotect, but I was curious if there is another way.

 

[Rick Rothstein]

Does anyone know if we can restrict entry to a worksheet thru a userform only?

I think it can be done through protect unprotect, but I was curious if there is another way.

Set the worksheet's Visible property to xlSheetVeryHidden so the user does not even know it exists?

 

[saprater]

Thank You Rick, that is what I was looking for.