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
How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
HighAndWilder
Well-known Member
- Joined
- Nov 4, 2006
- Messages
- 608
- 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
- 212
- Replies
- 14
- Views
- 426
- Replies
- 2
- Views
- 170
- Replies
- 1
- Views
- 142
- Replies
- 4
- Views
- 741
