I am trying to open an xls file & a hidden file that has toolbars and macros.
How can I keep the file hidden but be able to view the toolbar from the
active workbook? I cannot use my personal.xls because this is a shared
workbook with users who are just your average joe, not familiar enough with
Excel to deal with installing add-ins or creating their own custom toolbars.
I can't store the toolbars or macros in the visible file either, because it
is refreshed and replaced each week.

Check out the below link on Add-Ins
http://www.fontstuff.com/vba/vbatut03.htm

If this post helps click Yes
---------------
Jacob Skaria


"jeremiah" wrote:

I am trying to open an xls file & a hidden file that has toolbars and macros.
How can I keep the file hidden but be able to view the toolbar from the
active workbook? I cannot use my personal.xls because this is a shared
workbook with users who are just your average joe, not familiar enough with
Excel to deal with installing add-ins or creating their own custom toolbars.
I can't store the toolbars or macros in the visible file either, because it
is refreshed and replaced each week.