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: 20
Default quick way to prohibit all editing/changes to workbook (2010)

I can protect cells and workbooks, but say I have a wb that isn't
isn't really setup to use those two macros (Protect Sheet, Protect
Wookbook). Is there an over all switch I can flip that simply says
"YOU CAN CHANGE NOTHING"

I'm not looking at this as a security issue, just one of sharing quick
and dirty sheets with others and precluding their inadvertent changes
--- kind of a PDF with scroll bars.

Thank you.
 
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
Easy way to add my custom button on Excel 2010 quick access toolbar? Chet Excel Programming 3 April 7th 10 03:16 PM
Easy way to add my custom button on Excel 2010 quick access toolbar? Chet Excel Discussion (Misc queries) 0 April 5th 10 10:21 PM
Method for protecting cells which still allows quick editing rbart3 Excel Discussion (Misc queries) 2 December 4th 09 04:24 PM
Excel 2002: Any quick way for editing VLOOKUP formulas ? Mr. Low Excel Discussion (Misc queries) 1 April 4th 08 04:50 PM
prohibit closing a workbook Christophero Excel Discussion (Misc queries) 2 April 4th 05 05:54 PM


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

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"