Secure a sheet

elmnas

Board Regular
Joined
Feb 20, 2015
Messages
206
Hello people,

I have made a excel form in vba.

I need a code snippet that makes the user is not allowed to change anything in the excel sheet or workbook, the only thing that can change the data in the excel its my form.

Could someone help me ?


here is a sample of the code :)

Code:
Private Sub UserForm_Initialize()


end sub
Thank you in advance
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
9,899
if you macro record the action you want Review > Protect Sheet, and then any issues bring the code back here
 

Forum statistics

Threads
1,082,478
Messages
5,365,780
Members
400,849
Latest member
candy2052

Some videos you may like

This Week's Hot Topics

Top