| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. Save it as 'Read Only', perhaps! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
quick way to prohibit all editing/changes to workbook (2010)
On Mar 12, 11:43*am, GS wrote:
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. Save it as 'Read Only', perhaps! -- Garry Free usenet access athttp://www.eternal-september.org Classic VB Users Regroup! * comp.lang.basic.visual.misc * microsoft.public.vb.general.discussion DAMN! hahahah |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy way to add my custom button on Excel 2010 quick access toolbar? | Excel Programming | |||
| Easy way to add my custom button on Excel 2010 quick access toolbar? | Excel Discussion (Misc queries) | |||
| Method for protecting cells which still allows quick editing | Excel Discussion (Misc queries) | |||
| Excel 2002: Any quick way for editing VLOOKUP formulas ? | Excel Discussion (Misc queries) | |||
| prohibit closing a workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
