PDA

View Full Version : VBA code to lock the active sheet



Master_Viper
01-23-2017, 07:52 AM
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
01-23-2017, 08:35 AM
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
01-23-2017, 08:46 AM
Just simply putt his code into thisworkbook

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