| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically it should be converted
Thank you so much for your help....
"Gord Dibben" wrote: You said in an earlier post that "Not only this macro I've so many but they are not working." Perhaps your ToolsOptionsSecurityMacro Security is set to High or Very High which disables macros with no warning message. Try setting to Medium. Gord On Wed, 23 Jan 2008 22:08:13 -0800, Srikanth wrote: Hi Gord, I've pasted to worksheet module... No Results.. Please help me in doing this.. "Gord Dibben" wrote: Did you copy/paste to the worksheet module? See Ron de Bruin's site for where to store various types of code. http://www.rondebruin.nl/code.htm Gord On Fri, 28 Dec 2007 00:51:01 -0800, Srikanth wrote: Hi, Macros are not working when i've pasted in VB.. Kindly help me in getting this done. Not only this macro I've so many but they are not working. I've pasted and saved that VB. But No results. Any Ideas ???????? "Gord Dibben" wrote: Here is some event code for the worksheet. Works on columns 1 through 8.............edit to suit. Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column 8 Then Exit Sub On Error GoTo ErrHandler Application.EnableEvents = False Target.Formula = UCase(Target.Formula) ErrHandler: Application.EnableEvents = True End Sub This is event code. Right-click on the sheet tab and "View Code". Copy/paste into that sheet module. As you enter text in any cell it will change to CAPS. Will not change existing text unless you F2ENTER on those but will change all new text entries. Gord Dibben MS Excel MVP On Wed, 26 Dec 2007 20:45:00 -0800, Srikanth wrote: Hi All, I've a query regarding attendance sheet in excel. If we key in lower case letter it shud take it as upper case. ANY IDEAS???? Thanks in Advance... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Answer to 2/29 gets converted to 2/1 | Excel Discussion (Misc queries) | |||
| Answer to 2/29 gets converted to 2/1 | Excel Discussion (Misc queries) | |||
| Numbers entered are being automatically converted ? | Excel Discussion (Misc queries) | |||
| characters automatically converted to arabic fonts | Excel Discussion (Misc queries) | |||
| Can Comments be automatically converted to text cell values? | Excel Discussion (Misc queries) | |||
Threaded Mode
