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.
Any help would be apreciated.
Please Login or Register to view this content.
Last edited by JosephP; 03-12-2013 at 12:26 PM. Reason: add code tags
Your code works on my excel 2010, you can tray with
instead ofPlease Login or Register to view this content.
Please Login or Register to view this content.
If solved remember to mark Thread as solved
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
also note that formula cells do not trigger a change event anyway except when the formula is first entered into the cellPlease Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Replaced the first line with the other one and it made no difference when I type lowercase and press return it stays in lowercase
Changed the script still doing the same thing, only seems to effect the one workbook as I am using it sucessfully on another one?
then there must be some code in the workbook that disables events-run this
and then check if the lower to upper conversion worksPlease Login or Register to view this content.
Do I put them one after the other on each worksheet?
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
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?
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
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?
you should skip dates and numbers
Please Login or Register to view this content.
Many thanks JosephP.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks