These attachment links don't work in the Microsoft Newsgroup where most
people are reading your post.

I gave a code example. Perhaps that is not what you are doing.

there is a month function both in VBA and in Excel (worksheetfunction).

It returns a number equivalent to the month such that Jan is a 1 and
December is a 12.

Use that to find out what column to work with.

--
Regards,
Tom Ogilvy

melchead wrote in message
...
Tom,

Thanks for the reply but I am not sure what and how to use the
month(date) as you describe. I have searched the internet forums for a
solution but I am still in the dark.

Is it correct to place month(9) as september?
Where do I put in the month() function?

could you do a small example for me please.

As I explained previously I have a form which the user must complete on
a monthly basis. if he changes any of the data in the current month
then it must be accepted, but if he opens the form again and the month
has changed to say October then he can only update data to the October
column.

I have attached the spreadsheet in question which will make it clear.
Thanks again
Andre

File Attached: http://www.exceltip.com/forum/attach...?postid=280197
(ref_alrev1.xls)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/