Hello again my friends, and welcome to your favorite part of the Newsletter, "War Games", where you can find information about CC Tournaments!
WorldCup4James has prepared an excellent introduction to the problem of reserves and replacing missing players. He also is again covering Join This? Or Not! As for my own contribution, I had a chance to interview IcePack this weekend, and I hope you enjoy the results.
DaveH has another installment in his excellent Dave's Tips series. This is number 18 if you're keeping track! Pursuant to a suggestion by [player]greenoaks[/player], we will soon publish the complete Dave's archive in their entirety in some publically-accessible place (probably Tournament Q&A) so you can go through them step-by-step without needing to search through old newsletter issues.
In the next issue, we expect to have an article by our newest reporter, [player]woopintroysbutt[/player]! We are also still looking for another new reporter, one who will cover the TPA beat. If you're a TPA enthusiast, please give this some thought!
[player]Dukasaur[/player] Tournament Executive
Missing in Action: TO Reserve Policiesby WorldCup4James
Tournament Tipsby DaveH [spoiler=Customizing Excel Menus]In previous articles I have shown how macros can be used to automate tournament results updating. These macros were accessed by a button, but they can also be accessed from a new Excel menu and in this article I'll show how you can customize your menu task bar to include sub-menus that run different macros.
The coding looks rather complex, so the best way of getting to know what is happening is to install a new menu bar and then you can more easily see what is happening. OK lets start Excel and carry out the following sequence:
* Create a new spreadsheet; * Press Alt+F11 from Excel which opens the Visual Basic Editor window; * In the top left pane you get "VBAProject (Book1)"; * Open the menu and sub-menu by clicking the [+] buttons; * Click "ThisWorkbook" to open a new window on the right; * Copy the following code and paste into the blank window;
Private Sub Workbook_Open() Dim cmbBar As CommandBar Dim cmbControl As CommandBarControl
Set cmbBar = Application.CommandBars("Worksheet Menu Bar") Set cmbControl = cmbBar.Controls.Add(Type:=msoControlPopup, temporary:=True) 'adds a menu item to the Menu Bar With cmbControl .Caption = "&My Macros" 'names the menu item With .Controls.Add(Type:=msoControlButton) 'adds a dropdown button to the menu item .Caption = "My Macro No 1" 'adds a description to the menu item .OnAction = "RunMyMacro1" 'runs the specified macro .FaceId = 1098 'assigns an icon to the dropdown End With With .Controls.Add(Type:=msoControlButton) .Caption = "My Macro No 2" .OnAction = "RunMyMacro2" .FaceId = 108 End With With .Controls.Add(Type:=msoControlButton) .Caption = "My Macro No 3" .OnAction = "RunMyMacro3" .FaceId = 21 End With End With End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean) On Error Resume Next 'in case the menu item has already been deleted Application.CommandBars("Worksheet Menu Bar").Controls("My Macros").Delete 'delete the menu item End Sub
* On the "Run" menu, click on "Run Sub./UserForm" (or press F5); * On the Spreadsheet a new menu heading appears "My Macros"; * Clicking this opens up the menu to reveal three new sub-menus, each with pictures next to them.
OK, so let's look into the coding:-
.Caption = "&My Macros" ; Your main menu title can be inserted here; The sub menus are defined by the following set of code lines; With .Controls.Add(Type:=msoControlButton); This "With/End With" set of codes adds a new sub-menu; .Caption = "My Macro No 1"; Sub-menu title .OnAction = "RunMyMacro1"; Assign the macro name here; .FaceId = 1098; Adds a nice little picture (try changing the number!) End With
This set of 5 code lines are repeated as many times as you need sub-menus.
If you want to see more pictures - there are hundreds! - you can download a browser to look through these icons at http://skp.mvps.org/faceid.htm. Have fun!
(These "tips" are ones that I have tried to make it a bit easier in managing my own tournaments. I am sure there are different and better methods than these, so please let me know. Any queries on the above I'll be glad to respond to! Please note that I use Excel 2003, so there may be variation in the menu instructions if you have Excel 2007)[/spoiler] Join This? Or Not!by WorldCup4James
If you would like to apply to join the Tournament News Team, PM Tournament Executive, Dukasaur!
Submitting Your Own Articles
If you have a story for the Tournament section you think the ConquerClub Community would find interesting, you can submit your articles to [player]Dukasaur[/player] and you may just see your article published in the Newsletter!
Subscription
Did you enjoy this Issue? Have you subscribed to the Newsletter yet?
If you want each and every issue of the ConquerClub Dispatch delivered right into your Inbox, then Subscribe Here!
