Viewing an Excel Worksheet as a Form only... 1

[deevaetodin]

Was wondering if anyone could explain how I can adjust the options of a worksheet in an excel workbook so that all the user that access' that worksheet has access to are the form controls?

Is there a certain way that I need to protect the worksheet so that the user cannot navigate throughout the cells.

I would like to make somewhat similar to an HTML form within the workbook.

Thanks in advance for any help.

 

[Databaseguy]

When you start the worksheet:

Private Sub Worksheet_Activate()
yourform.Show
End Sub

When you close the form:

Private Sub UserForm_Deactivate()
Workbooks("YourWorkbooj=k&quot.Close SaveChanges:=True
End Sub

 

[deevaetodin]

Thank you very much.

Last question.

How do I get the code to run automatically when the worksheet is accessed or opened.

Is this possible?

Thanks again....

 

[Databaseguy]

Private Sub Workbook_Open()
'Puyt your code here....
End Sub

 

[JrClown]

I simply share my Excel forms allowing multiple users to make changes at the same time and place them in a read-only directory in the server and have users copy them from there. But VBA works just fine also.

"The reward of one duty done is the power to fulfill another"
<%
Jr_Clown@Yahoo.com
%>
​