The nitrogen in our DNA, the calcium in our teeth, the iron in our blood, the carbon in our apple pies were made in the interiors of collapsing stars. We are made of starstuff.
i want to pass word protect all my sheets in my workbook at one time.not each sheet at a time. because there are 23 sheets in each workbook
Answer from Richard Rost:
You can password protect the current workbook as a whole, or you can apply cell protection to individual sheets. Without VBA programming, I don't know of any way to protect multiple sheets at the same time.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
