Where I work they are going to be ugrading Office 2003 to 2007
version. I am an Excel 2003 Power User you could say. I have many
drop down menus that I have customized and tons of macros and macro
buttons and these took years to develop over time. I am able to
"perform my magic" as my boss would say and I would take complex
reports and manipulate them how they want and in a minimal amount of
time. I was called the Data Diva here.

I understand that Excel 2007 won't allow those functions for me. I
have read about the addins to give back the class view toolbar and I
was told I would not be allowed to purchase it. Is there any work
around to this? My work production will drop significantly. Nobody
where I work really understands because they don't need all of the
functions I do. That is why I do this for them.

Is there a VB code that I can copy and put in as my own add-in to
create the classic custom toolbar myself? I have read that you can
save your toolbars in 2003 and save them as an add-in and when you
open it in 2007 it brings back the classic toolbar. I don't know if
that works because we haven't been upgraded yet.

This will greatly affect my work since 85% of my work is in Excel.

Please help!!
Thanks

http://www.google.com/search?sourcei...lassic+toolbar

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Linda T" <Linda (E-Mail Removed)> wrote in message
news:BB9D2A0A-1BD9-45A6-988C-(E-Mail Removed)...
> Where I work they are going to be ugrading Office 2003 to 2007
> version. I am an Excel 2003 Power User you could say. I have many
> drop down menus that I have customized and tons of macros and macro
> buttons and these took years to develop over time. I am able to
> "perform my magic" as my boss would say and I would take complex
> reports and manipulate them how they want and in a minimal amount of
> time. I was called the Data Diva here.
>
> I understand that Excel 2007 won't allow those functions for me. I
> have read about the addins to give back the class view toolbar and I
> was told I would not be allowed to purchase it. Is there any work
> around to this? My work production will drop significantly. Nobody
> where I work really understands because they don't need all of the
> functions I do. That is why I do this for them.
>
> Is there a VB code that I can copy and put in as my own add-in to
> create the classic custom toolbar myself? I have read that you can
> save your toolbars in 2003 and save them as an add-in and when you
> open it in 2007 it brings back the classic toolbar. I don't know if
> that works because we haven't been upgraded yet.
>
> This will greatly affect my work since 85% of my work is in Excel.
>
> Please help!!
> Thanks

If you are a power user you will feel like you are stuck in a Kafka like
environment where everything is hidden beyond imagination

I still use 2003 95% of the time (I have them both installed) and I was a
beta tester etc. You can make the change less hard by putting a lot of stuff
on the QOT also known as the Quick Access Toolbar. Of course there are some
improvements as well but overall it is not an upgrade IMHO

--


Regards,


Peo Sjoblom


"Linda T" <Linda (E-Mail Removed)> wrote in message
news:BB9D2A0A-1BD9-45A6-988C-(E-Mail Removed)...
> Where I work they are going to be ugrading Office 2003 to 2007
> version. I am an Excel 2003 Power User you could say. I have many
> drop down menus that I have customized and tons of macros and macro
> buttons and these took years to develop over time. I am able to
> "perform my magic" as my boss would say and I would take complex
> reports and manipulate them how they want and in a minimal amount of
> time. I was called the Data Diva here.
>
> I understand that Excel 2007 won't allow those functions for me. I
> have read about the addins to give back the class view toolbar and I
> was told I would not be allowed to purchase it. Is there any work
> around to this? My work production will drop significantly. Nobody
> where I work really understands because they don't need all of the
> functions I do. That is why I do this for them.
>
> Is there a VB code that I can copy and put in as my own add-in to
> create the classic custom toolbar myself? I have read that you can
> save your toolbars in 2003 and save them as an add-in and when you
> open it in 2007 it brings back the classic toolbar. I don't know if
> that works because we haven't been upgraded yet.
>
> This will greatly affect my work since 85% of my work is in Excel.
>
> Please help!!
> Thanks

Should have been QAT

--


Regards,


Peo Sjoblom


"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If you are a power user you will feel like you are stuck in a Kafka like
> environment where everything is hidden beyond imagination
>
> I still use 2003 95% of the time (I have them both installed) and I was a
> beta tester etc. You can make the change less hard by putting a lot of
> stuff on the QOT also known as the Quick Access Toolbar. Of course there
> are some improvements as well but overall it is not an upgrade IMHO
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
> "Linda T" <Linda (E-Mail Removed)> wrote in message
> news:BB9D2A0A-1BD9-45A6-988C-(E-Mail Removed)...
>> Where I work they are going to be ugrading Office 2003 to 2007
>> version. I am an Excel 2003 Power User you could say. I have many
>> drop down menus that I have customized and tons of macros and macro
>> buttons and these took years to develop over time. I am able to
>> "perform my magic" as my boss would say and I would take complex
>> reports and manipulate them how they want and in a minimal amount of
>> time. I was called the Data Diva here.
>>
>> I understand that Excel 2007 won't allow those functions for me. I
>> have read about the addins to give back the class view toolbar and I
>> was told I would not be allowed to purchase it. Is there any work
>> around to this? My work production will drop significantly. Nobody
>> where I work really understands because they don't need all of the
>> functions I do. That is why I do this for them.
>>
>> Is there a VB code that I can copy and put in as my own add-in to
>> create the classic custom toolbar myself? I have read that you can
>> save your toolbars in 2003 and save them as an add-in and when you
>> open it in 2007 it brings back the classic toolbar. I don't know if
>> that works because we haven't been upgraded yet.
>>
>> This will greatly affect my work since 85% of my work is in Excel.
>>
>> Please help!!
>> Thanks
>
>

For the OP

If you use many macro's you can use this add-in maybe ?
http://www.rondebruin.nl/qat.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Peo Sjoblom" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> If you are a power user you will feel like you are stuck in a Kafka like
> environment where everything is hidden beyond imagination
>
> I still use 2003 95% of the time (I have them both installed) and I was a
> beta tester etc. You can make the change less hard by putting a lot of stuff
> on the QOT also known as the Quick Access Toolbar. Of course there are some
> improvements as well but overall it is not an upgrade IMHO
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
> "Linda T" <Linda (E-Mail Removed)> wrote in message
> news:BB9D2A0A-1BD9-45A6-988C-(E-Mail Removed)...
>> Where I work they are going to be ugrading Office 2003 to 2007
>> version. I am an Excel 2003 Power User you could say. I have many
>> drop down menus that I have customized and tons of macros and macro
>> buttons and these took years to develop over time. I am able to
>> "perform my magic" as my boss would say and I would take complex
>> reports and manipulate them how they want and in a minimal amount of
>> time. I was called the Data Diva here.
>>
>> I understand that Excel 2007 won't allow those functions for me. I
>> have read about the addins to give back the class view toolbar and I
>> was told I would not be allowed to purchase it. Is there any work
>> around to this? My work production will drop significantly. Nobody
>> where I work really understands because they don't need all of the
>> functions I do. That is why I do this for them.
>>
>> Is there a VB code that I can copy and put in as my own add-in to
>> create the classic custom toolbar myself? I have read that you can
>> save your toolbars in 2003 and save them as an add-in and when you
>> open it in 2007 it brings back the classic toolbar. I don't know if
>> that works because we haven't been upgraded yet.
>>
>> This will greatly affect my work since 85% of my work is in Excel.
>>
>> Please help!!
>> Thanks
>
>