View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jbJB jbJB is offline
external usenet poster
 
Posts: 2
Default protect more than one sheet at a time

How can I protect more than one sheet at a time. If I select all sheets in a
workbook, the dropdown menu will not allow me to protect all sheets at once.
Instead I have to manually protect each sheet which can be very
timecomsumming if I have over 50 sheets in a workbook.