Posted to microsoft.public.excel.programming

NOPIK

external usenet poster

Posts: 50

Thank You all for the help..one more question..for now

Is it possible to protect data that are seven days or older so they cannot
be altered anymore after the period expired while new data can still be
entered?

if (Date-DateCell.Value)6 then
DateCell.Locked=True
end if

Remember idiotic Excel behaviour: to protect cells you need to set
Sheet protection (with empty password to activate cells protection
only)

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
Newbie Question - Subtraction Formula Question	[email protected]	Excel Discussion (Misc queries)	3	May 5th 06 05:50 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good	davegb	Excel Programming	1	May 6th 05 06:35 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you	[email protected]	Excel Programming	0	April 27th 05 07:46 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you	[email protected]	Excel Programming	23	April 23rd 05 09:26 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you	[email protected]	Excel Programming	0	April 22nd 05 03:30 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us