LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Locked cells are still able to be selected with proper protection Jesse Excel Discussion (Misc queries) 2 March 2nd 10 04:06 PM
Protection & Locked issue ah Excel Discussion (Misc queries) 1 August 20th 08 08:30 AM
locked out of my sheet for read only wwoody Excel Worksheet Functions 1 March 1st 06 01:52 AM
ADO: Read Excel file that is in use (locked) Stanza Excel Programming 2 March 29th 05 02:39 PM
setting Select (Un)Locked Cells in Worksheet Protection rbyte Excel Programming 1 September 26th 04 05:14 AM


All times are GMT +1. The time now is 02:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"