View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Macro to select all sheets

Macro starts

ActiveSheet.Unprotect Password:="justme"

Macro does its stuff

ActiveSheet Protect Password:="justme"

End Sub

On Wed, 26 Mar 2008 23:08:01 -0700, belvy123
wrote:

Hi Again
I am having one issue that i did not mention before
I have protection on all sheets to keep people from deleting formulas.
what do i need to add to this code to unprotect the sheets as the code trys
to clear the cells

Thanks