I am trying to create a data entry form that can be sent to employees via an excel link that will only allow them to see the form and what they are entering on the form, not the rest of the worksheet. Is this possible? If not with Excel alone, is this possible with Excel and another program?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Data Entry Forms and Worksheet Restrictions
- Thread starter IR84
- Start date
-
- Tags
- data collection forms help
Excel Facts
Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
HighAndWilder
Well-known Member
- Joined
- Nov 4, 2006
- Messages
- 660
- Office Version
- 365
- Platform
- Windows
You can hide the application and show the form.
Application.Visible = False
UserForm1.Show
You can run this when you load the workbook.
Application.Visible = False
UserForm1.Show
You can run this when you load the workbook.
Upvote
0
Thank you!
You can hide the application and show the form.
Application.Visible = False
UserForm1.Show
You can run this when you load the workbook.
Upvote
0
Similar threads
- Replies
- 0
- Views
- 223
- Replies
- 14
- Views
- 433
- Replies
- 2
- Views
- 228
- Replies
- 1
- Views
- 153
- Replies
- 4
- Views
- 786
