Posted to microsoft.public.excel.programming

John[_78_] John[_78_] is offline

external usenet poster

Posts: 87

Protect ALL cells If Q

I want to protect all cells in a workbook if the Contents of cell B1 7. My
thinking is that if the value of Cell B1 7 then the worksheet should not
be worked on, kind of a security feature

Is there any such code I should use?

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
protect cells in excel, but also allow a search in those cells?	LindaAlex	Excel Worksheet Functions	2	January 28th 10 02:51 PM
How do I protect cells or a range of cells in excel spreadsheet?	Abundance	Excel Worksheet Functions	1	July 28th 09 11:03 PM
Protect Only Certain Cells	bgcooker	Excel Discussion (Misc queries)	2	March 25th 09 03:38 PM
Protect Cells ???	Jcraig713	Excel Discussion (Misc queries)	2	January 27th 06 02:57 PM
about protect just cells	tjtjjtjt	Excel Discussion (Misc queries)	3	December 7th 04 01:35 PM

All times are GMT +1. The time now is 10:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us