Passprotect

Question

i want to passprotect all my sheets in my workbook at one time.not each sheet at a time. because there are 23 sheets in each workbook

Answer

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.