VBA Script has stopped working

[Philfy]

HI

I am using the following script which I found on the net but it seems to have stopped working. The workbook contains 52 spreadsheets and I have put this script on each one. It turns whatever is entered into capitals, we when it was working it did anyway.

Please Login or Register  to view this content.

Any help would be apreciated.

[patel45]

Your code works on my excel 2010, you can tray with

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

[JosephP]

if you change cells in a change event you must disable events and you ought to loop in case more than one cell is changed

Please Login or Register  to view this content.

also note that formula cells do not trigger a change event anyway except when the formula is first entered into the cell

[Philfy]

Replaced the first line with the other one and it made no difference when I type lowercase and press return it stays in lowercase

[Philfy]

Changed the script still doing the same thing, only seems to effect the one workbook as I am using it sucessfully on another one?

[JosephP]

then there must be some code in the workbook that disables events-run this

Please Login or Register  to view this content.

and then check if the lower to upper conversion works

[Philfy]

Do I put them one after the other on each worksheet?

[JosephP]

no-you only have to run that last code once now. if the change code works properly afterward it means that there is some other code in your workbook that is disabling events and you'll have to find and correct that

[Philfy]

I pasted the second code into the workbook page of Microsoft Visual Basic and ran it by clicking on run then on the run sub button that came up.

I then pasted the first code into the worksheet page of Microsoft Visual Basic and clicked on debug and then on compile.

It works again, many thanks.

Do I just need to paste the first code against each of the other worksheets?

As an extra question if someone else opens this spreadsheet on their machine, enters data on it, saves it, closes it and then I open it again on my machine will this effect the code?

[JosephP]

again, no-you only need to run the code once to reset events. everything should just work after that

the code should not be affected by others using the file

[Philfy]

This script is causing the date to appear in the American format of mm/dd/yyyy and when I copy the date cell down it adds 1 to the year instead of the day.

Any ideas?

[JosephP]

you should skip dates and numbers

Please Login or Register  to view this content.

[Philfy]

Many thanks JosephP.