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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.