View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
helen helen is offline
external usenet poster
 
Posts: 105
Default Protecting Sheets with VBA

I have a user who feels they need to password protect some of the cells on a
sheet befor they distribute their sheet. The problem is they are a little
absent minded and forget to go to the Tools=Protection=Protect Sheet menu
item and lock the sheet before they save it.

Is it possible upon closing to lock the sheet with the password they used to
unlock it with?