Posted to microsoft.public.excel.programming

Bill[_33_] Bill[_33_] is offline

external usenet poster

Posts: 11

Please Help!!!! If statement, lock and unlock cells

Hi,

The spreadsheet has 2000 records and 30 columns. There are many blanks so I
just want to lock all the data that fill in cells and unlock for blank cells
for me to input the data. Is there a way to make the cell turn to bold
where I update the blank cell only.

Please help!!! Your help would be much apprecated.

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
Using a Check Box to Lock/Unlock Cells	[email protected]	Excel Discussion (Misc queries)	3	April 27th 23 11:43 AM
Lock/Unlock cells	BFife	Excel Worksheet Functions	2	October 25th 06 03:20 PM
lock and unlock cells programatically	call_Vishwa[_2_]	Excel Programming	1	June 21st 05 07:55 PM
Lock and Unlock Cells	Peter	Excel Programming	5	January 29th 05 04:32 PM
Lock and Unlock cells using VBA	Peter	Excel Discussion (Misc queries)	1	January 29th 05 02:00 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us