View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DaveO DaveO is offline
external usenet poster
 
Posts: 94
Default Decalring Workbook level arrays.

How do I go about declaring a workbook array that I can use at any point
during a sub?

The problem I have is this...

I'm hiding a users toolbars and creating some of my own, for a specific
application I'm developing. When they open the Workbook I assign all enabled
commandbars to an array so I can do what I want with them. When they close
the workbook I want to re-enable all of the ones I disabled earlier, but
can't see how to do it.

I'm using Office 2000.

Any help would be greatly appreciated.