View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dale... Dale... is offline
external usenet poster
 
Posts: 1
Default spread sheet protection over several tabs

i would like to be able to turn worksheet protection on and off over several
tabs at one time in a workbook. i have the same range of protected cells on
each tab and in order to edit or change the ranges accross several tabs i
have to turn the protection off by tab. is there a way to select several
tabs at one time and turn protection off for the selected tabs?

Dale...