How can I the password to apply automatically. This gives me an error.
Also can I set it so I can copy data form a specific column [e]or from the status bar?
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFiltering:=True "password"