Posted to microsoft.public.excel.programming

Phil Hageman Phil Hageman is offline

external usenet poster

Posts: 80

Clearing Unprotected Cells

What would the macro code be to clear all unprotected
cells in the current worksheet? Would put this macro in
Personal.xls

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
Unprotected cells	Mainer	Excel Worksheet Functions	2	October 13th 09 02:37 AM
Protected/Unprotected Cells	LtGator	Excel Discussion (Misc queries)	0	August 10th 09 07:01 PM
Clearing cells without clearing formulas	marsjune68	Excel Discussion (Misc queries)	2	April 10th 09 07:39 PM
tab between unprotected cells	LesaT	Excel Discussion (Misc queries)	1	November 3rd 05 11:30 PM
put zero value to unprotected cells	GUS	Excel Programming	2	September 14th 03 10:54 PM

All times are GMT +1. The time now is 11:30 AM.

About Us

"It's about Microsoft Excel"