View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shamsul Islam Shamsul Islam is offline
external usenet poster
 
Posts: 6
Default Protected Worksheets

Hi

I have a workbook I want to send to other users. This
workbook has protected worksheets. The worksheets have to
be password protected.

How do I create a macro which will unprotect and after
completed the task protect the worksheet without asking
the user for the password I have set.

Regards

Sham