Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
-I opened a new spreadsheet
-I created two macros and set them to all workbooks ---Sub ConvertToUpperCase() Dim Rng As Range For Each Rng In Selection.Cells If Rng.HasFormula = False Then Rng.Value = UCase(Rng.Value) End If Next Rng End Sub Sub ConvertToLowerCase() Dim Rng As Range For Each Rng In Selection.Cells If Rng.HasFormula = False Then Rng.Value = LCase(Rng.Value) End If Next Rng End Sub -I created a custom Toolbar and added two custom buttons, one for the uppercase, one for the lowercase macro -I attached the toolbar to the workbook using Tools/Customize/Toolbars/Attach -I saved the workbook as a template, changecase.xlt, in C:\Documents and Settings\me\Application Data\Microsoft\Templates -I opened a new workbook and the custom toolbar was there -I typed in some text and selected it and clicked the change to upper case button -the case changed, but the file changecase.xlt opened What have I done incorrectly? I, of course, do no want the template to open. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Murray
How did you open a new workbook? The workbook you get with FileNewBlank Workbook is not based on the changecase Template. Try opening a new workbook through FileNew...TemplatesOn my Computer. Browse to your changecase template and open it. It will open as changecase1.xls and you macros will be available. I would save the workbook as an add-in and load it through ToolsAdd-ins. Any macros you place in that add-in will be available for any open workbook. Gord Dibben Excel MVP On Tue, 6 Dec 2005 12:48:02 -0800, Murray wrote: -I saved the workbook as a template, changecase.xlt, in C:\Documents and Settings\me\Application Data\Microsoft\Templates -I opened a new workbook and the custom toolbar was there |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you Gord,
Your reply was spot on. I was not opening the Template correctly. I followed your suggestion and saved the .xls file as an add-in. We use group policy to redirect user's documents and settings to their H drive. With the add-in solution, I can simply send instructions to users on how to add this custom toolbar as an add-in. The .xla file is copied to: C:\Documents and Settings\%username%\Application Data\Microsoft which of course is the user's H drive, so they have write permission. Thanks again, Murray |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the feedback Murray
Glad you got it sorted. If you wanted to get really fancy you could create the Toolbar on the fly when the Add-in loads. Then no need for attaching the Toolbar. Gord On Tue, 6 Dec 2005 15:27:02 -0800, Murray wrote: Thank you Gord, Your reply was spot on. I was not opening the Template correctly. I followed your suggestion and saved the .xls file as an add-in. We use group policy to redirect user's documents and settings to their H drive. With the add-in solution, I can simply send instructions to users on how to add this custom toolbar as an add-in. The .xla file is copied to: C:\Documents and Settings\%username%\Application Data\Microsoft which of course is the user's H drive, so they have write permission. Thanks again, Murray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom color palette does not get transferred with the workbook. Excel 2003 | Excel Discussion (Misc queries) | |||
Template Wizard w/Data Tracking in Excel 2003 Pro? | Excel Discussion (Misc queries) | |||
How do I auto number cells in an Excel template? | Excel Discussion (Misc queries) | |||
Excel template to load automatically as the default template? | Excel Discussion (Misc queries) | |||
How do I stop the Reviewing toolbar from showing up in Excel? | Excel Discussion (Misc queries) |