Passprotect

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:50 PM GMT

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.

Advertisement

©2024 eLuminary LLC. All rights reserved.