View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason Kontkanen Jason Kontkanen is offline
external usenet poster
 
Posts: 1
Default Setting a workbooks protection/read only/locked

Hello,

I've read various pages about locking ranges, protection, etc, but none of
it seems to work across the board. From VB, I'm opening a workbook, and the
entire thing should be locked. The user should be able to scroll and see
everything, but they shouldn't be able to edit anything. I specify read
only when I open it, and i call .Protect for the workbook, and as a test I
do .Protect DrawingObjects:=True, Contents:=True, Scenarios:=True,
UserInterfaceOnly:=True to protect the only sheet in the workbook. What
ends up happening is part of the worksheet is protected, but not the entire
worksheet. What am I doing wrong, and what needs to be done to do it right?

Thanks,
Jason