Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Macro
I have a set of macros which Changes the case within Excel. This is in my
Personal.xls workbook which is hidden, so the macro won't run The macro is as follows Option Explicit Dim objCell As Object Sub ChangeCase_Show() frmCase.Show End Sub Sub DoCaseChange() If frmCase.optLower = True Then LowerCase ElseIf frmCase.optUpper = True Then UpperCase Else TitleCase End If End Sub Sub LowerCase() For Each objCell In Selection objCell.Value = LCase(objCell.Formula) Next objCell End Sub Sub UpperCase() For Each objCell In Selection objCell.Value = UCase(objCell.Formula) Next objCell End Sub Sub TitleCase() For Each objCell In Selection objCell.Value = Application.Proper(objCell.Formula) Next objCell End Sub can anyone tell me how to run from a hidden, unshared, unprotected workbook |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) |