VBA code to lock the active sheet

[Master_Viper]

Hello All,

Is there any vba code to protect the active sheet not to edit unless they will open the userform?

Thanks!


Solved problem.

[Paul_Hossler]

If you solved the problem, why not post the solution so that others can learn?

Also, in [Thread Tools] in the menu above our first post, you can mark the thread "Solved:"

[Master_Viper]

Just simply putt his code into thisworkbook

Private Sub Workbook_Open()
Sheet3.Protect Password:=True, UserinterfaceOnly:=True, AllowFiltering:=True
End Sub