Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default posted data in a range of cells can't change after three days

I hav little or no knowledge of how to write vb ocde. But this is what I am
trying to do: On friday say 03-10-06 data is posted in range B5:H5 and on
friday 03-17-06 data is posted in range B6:H6, on the third day after
entering data no changes can be made to that data. I am using excel 2002
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,092
Default posted data in a range of cells can't change after three days

Is this workbook shared on a network? If so, macros will not run. Does the
workbook get entries week after week after week? If so, when does it end and
a new one is started? Is there data adjacent to row 5 or in columns A and I
that you would not want protected? In other words, in the Current Region of
the entered data. Also keep in mind that any code that can be written can be
altered by the user or just set the computer clock back in time and make the
macro think it is a day before the cells are locked.

Mike F
"andycapp" wrote in message
...
I hav little or no knowledge of how to write vb ocde. But this is what I am
trying to do: On friday say 03-10-06 data is posted in range B5:H5 and on
friday 03-17-06 data is posted in range B6:H6, on the third day after
entering data no changes can be made to that data. I am using excel 2002



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Counting no of days of a specific range of days from a list Manikandan[_2_] Excel Discussion (Misc queries) 10 December 24th 09 12:26 PM
How do I add numbers in a range of data from days of the week? Peggy Excel Worksheet Functions 1 March 27th 09 12:11 PM
Color shading on cells posted 11/5/2008 ans. by Mr. Johnc ghinzrey New Users to Excel 6 November 19th 08 05:16 AM
Re Change 5 week days to 7 days in this formula pano Excel Worksheet Functions 7 February 1st 07 04:20 PM
Posted date in a range of cells that can't be edited after three d andycapp Excel Programming 0 March 18th 06 06:21 AM


All times are GMT +1. The time now is 06:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"