Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 20th 06, 05:19 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2
Default Customized Toolbar Deployment for Excel 2002

Hi-All of my users need to use an in-house, customized toolbar in Excel. Is
there a way I can mass deploy this toolbar, complete with button names,
without having to configure it at each individual workstation. Also, is
there a way I can import that same toolbar into Word? Thanks

  #2   Report Post  
Old September 21st 06, 11:12 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3
Default Customized Toolbar Deployment for Excel 2002

Dear Morgan,

According to your description, my understanding of this issue is: you would
like to deploy the Excel customized toolbar to all the users in the
organization. You do not want to configure toolbar at each individual
workstation.

If I have misunderstood your concern, please feel free to let me know.

Based on my research, you are able to use Profile Wizard to restore the
customized toolbar. We could use the Profile Wizard to save the Excel
settings to an .ops file, and use the .ops file to restore the Excel
setting to another machine. However, we are not able to restore the Excel
toolbar to Word. You need to customize the Word toolbar first and then save
the Word setting and the Excel setting to an .ops file, use the .ops file
to restore the Excel and Word toolbar on another machine. In all the
machines we need to install Office XP Resource Kit to run Profile Wizard to
save or restore setting.

To use the Profile Wizard, please do as follows:

1. Download and run the Office XP Resource Kit from the following site:
http://www.microsoft.com/downloads/d...c79-b248-4eb9-
8057-be0043f5b881&displaylang=en&Hash=zgF6htKvmbZzOiCq4 iluuTo7rdDEr5uPT19f2X
f0aQiJUfyq2%2b734lS8ny4JIrOIHxQvcPDcMerJPDS7c6cDfw %3d%3d

2. On a machine which has the customized toolbar, click Start-All
Programs-Microsoft Office Tools-Microsoft Office XP Resource Kit
Tools-Profile Wizard.
3. Click Next.
4. Select "Save the Settings from this machine", in the "Select the
application for which you want to Save/Restore Settings" field, select
"Microsoft Word" and "Microsoft Excel". Click the Browse button to select
the path to save the .ops file. Click Finish.
5. After the .ops file is generated, click Exit.
6. Copy the .ops file to another machine on which you would like to restore
the customized toolbar, launch Profile Wizard.
7. Click Next.
8. Select "Restore Previously Saved Setting", clear the check box of "Reset
to default before restoring Settings", in the "Select the application for
which you want to Save/Restore Settings" field, select "Microsoft Word" and
"Microsoft Excel". Click Browse to select the .ops file you copied to the
machine, click Finish.
9. Click Exit.
10. Launch Excel, are the customized toolbars in Excel?

For more detailed information, please refer to the following article:
http://office.microsoft.com/en-us/as...362571033.aspx
Using the Office Profile Wizard

Please try the suggestion and update me with the result at your earliest
convenience. We look forward to your reply.

Regards,
Alice Zhu

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.

  #3   Report Post  
Old September 21st 06, 11:55 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2
Default Customized Toolbar Deployment for Excel 2002

Thanks. I'll try it and let you know.

"Alice Zhu [MSFT]" wrote:

Dear Morgan,

According to your description, my understanding of this issue is: you would
like to deploy the Excel customized toolbar to all the users in the
organization. You do not want to configure toolbar at each individual
workstation.

If I have misunderstood your concern, please feel free to let me know.

Based on my research, you are able to use Profile Wizard to restore the
customized toolbar. We could use the Profile Wizard to save the Excel
settings to an .ops file, and use the .ops file to restore the Excel
setting to another machine. However, we are not able to restore the Excel
toolbar to Word. You need to customize the Word toolbar first and then save
the Word setting and the Excel setting to an .ops file, use the .ops file
to restore the Excel and Word toolbar on another machine. In all the
machines we need to install Office XP Resource Kit to run Profile Wizard to
save or restore setting.

To use the Profile Wizard, please do as follows:

1. Download and run the Office XP Resource Kit from the following site:
http://www.microsoft.com/downloads/d...c79-b248-4eb9-
8057-be0043f5b881&displaylang=en&Hash=zgF6htKvmbZzOiCq4 iluuTo7rdDEr5uPT19f2X
f0aQiJUfyq2%2b734lS8ny4JIrOIHxQvcPDcMerJPDS7c6cDfw %3d%3d

2. On a machine which has the customized toolbar, click Start-All
Programs-Microsoft Office Tools-Microsoft Office XP Resource Kit
Tools-Profile Wizard.
3. Click Next.
4. Select "Save the Settings from this machine", in the "Select the
application for which you want to Save/Restore Settings" field, select
"Microsoft Word" and "Microsoft Excel". Click the Browse button to select
the path to save the .ops file. Click Finish.
5. After the .ops file is generated, click Exit.
6. Copy the .ops file to another machine on which you would like to restore
the customized toolbar, launch Profile Wizard.
7. Click Next.
8. Select "Restore Previously Saved Setting", clear the check box of "Reset
to default before restoring Settings", in the "Select the application for
which you want to Save/Restore Settings" field, select "Microsoft Word" and
"Microsoft Excel". Click Browse to select the .ops file you copied to the
machine, click Finish.
9. Click Exit.
10. Launch Excel, are the customized toolbars in Excel?

For more detailed information, please refer to the following article:
http://office.microsoft.com/en-us/as...362571033.aspx
Using the Office Profile Wizard

Please try the suggestion and update me with the result at your earliest
convenience. We look forward to your reply.

Regards,
Alice Zhu

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.


  #4   Report Post  
Old September 22nd 06, 02:56 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3
Default Customized Toolbar Deployment for Excel 2002

Hi Morgan,

Thank you for your reply.

Please try my suggestions and update with the result at your earliest
convenience. I look forward to your reply.

Regards,
Alice Zhu

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you keep your toolbar customized the way you set it up? alitanna New Users to Excel 2 May 19th 06 08:20 AM
Toolbar problem Anthony Excel Discussion (Misc queries) 1 June 1st 05 01:05 AM
How can I save a customized Standard toolbar? TD Excel Discussion (Misc queries) 1 March 25th 05 08:06 PM
update row numbers after different active cells in macros followi. LMIV Excel Discussion (Misc queries) 11 February 16th 05 01:44 AM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 03:02 PM


All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017