Hallo, I am preparing a workbook with 3 worksheet. On each worksheet, there are 4 columns in use - column A and B are with text, that is locked and unchangable. Column C is for Currency and once the data are added, the cell locks and standard excel message about lock cell will appear. I programme it by this code and it works perfectly.
What I´ve needed further for column D was a date, that will appear once there is a data entry in column C and is unchabgable either. I found this code:
which works well on a blank excell sheet, but those 2 codes doesnt work together. If I pass them to VBA like this:
and I enter a value in column C, message appear in VBA: "COMPILE ERROR! Ambiguous name detected: Worksheet_change."
It is probably will be very minor think, but I have no clue what to do.
Thank you for your help.
Bookmarks