Thread: How to password protect an 2007 workbook without show readonly opt
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default How to password protect an 2007 workbook without show readonly opt
Hi Yazeed

If you set the protection you have a option to use read only or not

Use only the password to open in the dialog and it will work like you want

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Yazeed" wrote in message ...
Hi All,

I'm trying to set a password on a workbook using PIAs 2007, the problem is
when opening that workbook, a promot opens asking for a password and a
readonly button, i want to get rid of that readonly button and just protect
the workbook from opening without a password?



Thanks in advance
Reply With QuoteReply With Quote