Protected Worksheets

  • Thread starter Thread starter Shamsul Islam
  • Start date Start date
S

Shamsul Islam

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
 
Look in excel help at the protect and unprotect method.

If using xl2000 or earlier, you can set the userinterfaceonly property to
true and your macro can manipulate the worksheet. In xl2002 and later, you
have to supply the password to set this. You would include the password in
your code. Then protect the project in the VBE so the user can not see the
code.
 
How do you include the password in the code?
-----Original Message-----
Look in excel help at the protect and unprotect method.

If using xl2000 or earlier, you can set the userinterfaceonly property to
true and your macro can manipulate the worksheet. In xl2002 and later, you
have to supply the password to set this. You would include the password in
your code. Then protect the project in the VBE so the user can not see the
code.

--
Regards,
Tom Ogilvy




.
Click to expand...
 
Back
Top