View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Geof Wyght[_2_] Geof Wyght[_2_] is offline
external usenet poster
 
Posts: 38
Default Signaling the presence of a password

If you have protected the workbook windows then there is a
read-only ProtectWindows property that you can check.
Geof.
-----Original Message-----
Hey there,

Is there a way to find out, from inside a workbook,
if that workbook is password-protected or not.

Why.....?
I have created a workbook with some specific functions in
the buttonbar that should only be available to users that
have their workbook protected by a password, if not than
these buttons will not be enabled. I do not have to know
the password, just the knowledge that there is a password.

Thanks beforehand
Geert Nauta
.