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

Similar Threads

How do I install Microsoft Equation 3.0 back to Office 365? 0
"Compile error in table level validation expression " after format 0
Adding Heading to Table of Contents after a column break 1
Synchronization problems while moving folders to new email 1
Office 365 Outlook adding unwanted HTML to Email Body 0
alphabetizing a database with formuals after adding new data 1
Can't insert a new worksheet 8
Macro to re-protect sheet w/ original password after pasting valuesin new book 1

Top