LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Excel Application Level Global Variable

Hi,
I have another question:
I create my customzation pull down menu. when my excel Tool.xls open, it
will add pull down menu MyTool to the menu bar. when Tool.xls close, I will
remove it from menu bar. I did this in the code below:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
DeletePBRISMenu
End Sub

Private Sub Workbook_Open()
CreatePBRISMenu
End Sub

Now my problem is, if there are multiple Tool.xls(it could be copied and
renamed) opened, when first Tool.xls close, my pull down menu get removed. I
am thinking to add a global variable (MenuCount) to count the number of
opened tool.xls file. when a tool.xls opend, MenuCount++; a tool.xls closed,
MenuCount--. when MenuCount = 0, remove my pull down menu.
but it does not work. the reason I think is, my global variable is
document level, not application level. Then how I can set a application level
global variable? Or is there any other solution I should think about?
Thank you in advance




Wes


 
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
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? Daniel Excel Worksheet Functions 1 July 9th 05 03:05 AM
Code: Using Excel Application level Events Chris W[_3_] Excel Programming 0 February 27th 05 07:40 PM
Global Variable -- Excel / VBA Adam1 Chicago Excel Discussion (Misc queries) 3 February 23rd 05 12:03 AM
How to Reference Global Variable for external application. ajcross123 Excel Programming 4 July 29th 04 11:18 PM
Excel Global Variable Setting John Baker Excel Programming 8 November 25th 03 02:34 PM


All times are GMT +1. The time now is 12:47 AM.

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

About Us

"It's about Microsoft Excel"