Toolbar buttons

[Liz]

Is it possible to create a button on a toolbar for 'Transpose' to save me
going through 'paste special' each time.

[Bernie Deitrick]

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" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to create a button on a toolbar for 'Transpose' to save me
> going through 'paste special' each time.

[Liz]

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" <[email protected]> wrote in message
> news:[email protected]...
> > Is it possible to create a button on a toolbar for 'Transpose' to save me
> > going through 'paste special' each time.
>
>
>

[Bernie Deitrick]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > Is it possible to create a button on a toolbar for 'Transpose' to save me
>> > going through 'paste special' each time.
>>
>>
>>

[Liz]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > Is it possible to create a button on a toolbar for 'Transpose' to save me
> >> > going through 'paste special' each time.
> >>
> >>
> >>
>
>
>

[Chip Pearson]

> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> > Is it possible to create a button on a toolbar for
>> >> > 'Transpose' to save me
>> >> > going through 'paste special' each time.
>> >>
>> >>
>> >>
>>
>>
>>

[Liz]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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" <[email protected]> wrote in message
> >> >> news:[email protected]...
> >> >> > Is it possible to create a button on a toolbar for
> >> >> > 'Transpose' to save me
> >> >> > going through 'paste special' each time.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>