View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Restoring Attached Toolbar

try visible instead of enabled

"Steve" wrote:

I have an application that deletes my attached toolbar when the file is
closed. The problem I am having is when two files, using the same toolbar,
are opened, and one is then closed, the toolbar is deleted. When I go to the
view\toolbars\customize\attach window, it shows that the toolbar is still in
the workbook. I have tried using "Application.CommandBars("Equipment
List").Enabled = True", but that doesn't work. Is there a way I can restore
the toolbar without having to close, and re-open?

Thanks,
Steve