restoring toolbars
 

i want to open the .XLB file to restore the toolbars that i cleared with a
macro when a user opened my Excel program. i what to restore their settings
when they close my program. does anyone have an example of code for me

restoring toolbars
 

It depends on which toolbars you want to refresh:

Application.CommandBars("Picture").Visible = True
Application.CommandBars("Picture").Reset

and then repeat for:

Worksheet Menu Bar
Chart Menu Bar
Standard
Formatting
PivotTable
Chart
Reviewing
Forms
Stop Recording
External Data
Formula Auditing
Full Screen
Circular Reference
Visual Basic
Web


and any other bars you desire.
--
Gary''s Student - gsnu200718


"Josh C" wrote:

i want to open the .XLB file to restore the toolbars that i cleared with a
macro when a user opened my Excel program. i what to restore their settings
when they close my program. does anyone have an example of code for me