Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar buttons
Is it possible to create a button on a toolbar for 'Transpose' to save me
going through 'paste special' each time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar buttons
Liz,
Copy the macro below into your Personal.xls, then add a custom toolbar button and assign it the macro. When you want to transpose a range, copy it, select the destination anchor cell, and press your custom button. HTH, Bernie MS Excel MVP Sub PasteTranspose() If Application.CutCopyMode Then _ Selection.PasteSpecial Transpose:=True End Sub "Liz" wrote in message ... Is it possible to create a button on a toolbar for 'Transpose' to save me going through 'paste special' each time. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar buttons
Thanks very much.
I don't think I have a Personal.xls file. Do I need to set one up, or can it run from within a workbook template instead? Liz "Bernie Deitrick" wrote: Liz, Copy the macro below into your Personal.xls, then add a custom toolbar button and assign it the macro. When you want to transpose a range, copy it, select the destination anchor cell, and press your custom button. HTH, Bernie MS Excel MVP Sub PasteTranspose() If Application.CutCopyMode Then _ Selection.PasteSpecial Transpose:=True End Sub "Liz" wrote in message ... Is it possible to create a button on a toolbar for 'Transpose' to save me going through 'paste special' each time. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar buttons
Liz,
It would be much better from within Personal.xls, since it would be available at any time and be available within any workbook. You should set one up. Simply start the macro recorder, and select the option to store the macro in "Personal macro workbook" Excel will take care of creating it for you. Then store the previous code in that workbook, through the VB Editor. HTH, Bernie MS Excel MVP "Liz" wrote in message ... Thanks very much. I don't think I have a Personal.xls file. Do I need to set one up, or can it run from within a workbook template instead? Liz "Bernie Deitrick" wrote: Liz, Copy the macro below into your Personal.xls, then add a custom toolbar button and assign it the macro. When you want to transpose a range, copy it, select the destination anchor cell, and press your custom button. HTH, Bernie MS Excel MVP Sub PasteTranspose() If Application.CutCopyMode Then _ Selection.PasteSpecial Transpose:=True End Sub "Liz" wrote in message ... Is it possible to create a button on a toolbar for 'Transpose' to save me going through 'paste special' each time. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar buttons
Thanks very much for your reply. I'll try it out. I've always been a bit
wary of macros and avoided them, but maybe I have to start using them! Liz "Bernie Deitrick" wrote: Liz, It would be much better from within Personal.xls, since it would be available at any time and be available within any workbook. You should set one up. Simply start the macro recorder, and select the option to store the macro in "Personal macro workbook" Excel will take care of creating it for you. Then store the previous code in that workbook, through the VB Editor. HTH, Bernie MS Excel MVP "Liz" wrote in message ... Thanks very much. I don't think I have a Personal.xls file. Do I need to set one up, or can it run from within a workbook template instead? Liz "Bernie Deitrick" wrote: Liz, Copy the macro below into your Personal.xls, then add a custom toolbar button and assign it the macro. When you want to transpose a range, copy it, select the destination anchor cell, and press your custom button. HTH, Bernie MS Excel MVP Sub PasteTranspose() If Application.CutCopyMode Then _ Selection.PasteSpecial Transpose:=True End Sub "Liz" wrote in message ... Is it possible to create a button on a toolbar for 'Transpose' to save me going through 'paste special' each time. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar buttons
I've always been a bit
wary of macros and avoided them, but maybe I have to start using them! There's no reason to be wary of macros, and no reason to avoid them. Once you become even a bit proficient with VBA, you'll find that a whole new world of Excel opens up. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Liz" wrote in message ... Thanks very much for your reply. I'll try it out. I've always been a bit wary of macros and avoided them, but maybe I have to start using them! Liz "Bernie Deitrick" wrote: Liz, It would be much better from within Personal.xls, since it would be available at any time and be available within any workbook. You should set one up. Simply start the macro recorder, and select the option to store the macro in "Personal macro workbook" Excel will take care of creating it for you. Then store the previous code in that workbook, through the VB Editor. HTH, Bernie MS Excel MVP "Liz" wrote in message ... Thanks very much. I don't think I have a Personal.xls file. Do I need to set one up, or can it run from within a workbook template instead? Liz "Bernie Deitrick" wrote: Liz, Copy the macro below into your Personal.xls, then add a custom toolbar button and assign it the macro. When you want to transpose a range, copy it, select the destination anchor cell, and press your custom button. HTH, Bernie MS Excel MVP Sub PasteTranspose() If Application.CutCopyMode Then _ Selection.PasteSpecial Transpose:=True End Sub "Liz" wrote in message ... Is it possible to create a button on a toolbar for 'Transpose' to save me going through 'paste special' each time. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar buttons
Many thanks for your help with the macro for Transpose. I've managed to get
it into my personal.xls and it works wonderfully! Liz "Chip Pearson" wrote: I've always been a bit wary of macros and avoided them, but maybe I have to start using them! There's no reason to be wary of macros, and no reason to avoid them. Once you become even a bit proficient with VBA, you'll find that a whole new world of Excel opens up. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Liz" wrote in message ... Thanks very much for your reply. I'll try it out. I've always been a bit wary of macros and avoided them, but maybe I have to start using them! Liz "Bernie Deitrick" wrote: Liz, It would be much better from within Personal.xls, since it would be available at any time and be available within any workbook. You should set one up. Simply start the macro recorder, and select the option to store the macro in "Personal macro workbook" Excel will take care of creating it for you. Then store the previous code in that workbook, through the VB Editor. HTH, Bernie MS Excel MVP "Liz" wrote in message ... Thanks very much. I don't think I have a Personal.xls file. Do I need to set one up, or can it run from within a workbook template instead? Liz "Bernie Deitrick" wrote: Liz, Copy the macro below into your Personal.xls, then add a custom toolbar button and assign it the macro. When you want to transpose a range, copy it, select the destination anchor cell, and press your custom button. HTH, Bernie MS Excel MVP Sub PasteTranspose() If Application.CutCopyMode Then _ Selection.PasteSpecial Transpose:=True End Sub "Liz" wrote in message ... Is it possible to create a button on a toolbar for 'Transpose' to save me going through 'paste special' each time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbar buttons -- AS400 iSeries Transfer | Excel Discussion (Misc queries) | |||
I keep losing Toolbar buttons | Excel Discussion (Misc queries) | |||
How can I keep Toolbar Buttons on the toolbar? | Setting up and Configuration of Excel | |||
Excel should have toolbar buttons which allow subscript and super. | Excel Discussion (Misc queries) | |||
Toolbar Buttons | Excel Discussion (Misc queries) |