alphabetizing a database with formuals after adding new data

V

veganfury

Thank you for your help, as I had said I'm pretty new to all this.
figured out how to do this, but it does not seem to record the passwor
when I protect the worksheet. Am I screwing something up or am I no
able to record a password?

thanks so much

Mat
 
D

Debra Dalgleish

You can manually add the password to the code. For example:

ActiveSheet.Protect Password:="test", _
DrawingObjects:=True, _
Contents:=True, Scenarios:=True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top