Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Create an .xla

OK. Try this as an example:-

Sub auto_open()
Set myMenuBar = CommandBars.ActiveMenuBar
Set newMenu = myMenuBar.Controls.Add(Type:=msoControlPopup, _
Befo=8, Temporary:=True)
newMenu.Caption = "Wor&k"
Set ctrl1 = newMenu.Controls _
.Add(Type:=msoControlButton, ID:=1)
ctrl1.Caption = "Travel Claim"
ctrl1.TooltipText = "Travel Claim"
ctrl1.Style = msoButtonIcon
ctrl1.OnAction = "LoadTandS" 'name of subroutine to run for this
selection
Set ctrl2 = newMenu.Controls _
.Add(Type:=msoControlButton, ID:=1)
ctrl2.Caption = "Time Sheet"
ctrl2.TooltipText = "Time Sheet"
ctrl2.Style = msoButtonCaption
ctrl2.OnAction = "LoadTimesheet" 'name of subroutine to run
End Sub

Sub auto_close()
Application.CommandBars("Worksheet Menu Bar").Controls("Work").Delete
End Sub

"Dominique Feteau" wrote in message
...
Thanx for the response Bigwheel. To be honest, I dunno what I'd do

without
this board. I will need some help with that code. I'm a beginner with
writing the code, but can understand what the code is doing once it's been
written.



Reply
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
Create a macro to create excel line graph with coloured pointers anddata lables anuj datta Charts and Charting in Excel 1 September 30th 09 04:04 PM
How to create adress list so can mail merge and create labels? adecocq Excel Discussion (Misc queries) 2 October 25th 06 12:32 AM
How to create a form to insert a hyerlink.VBA code to create a for karthi Excel Discussion (Misc queries) 0 July 5th 06 11:26 AM
Create dictionary of terms, create first time user site Solitaire Jane Austin New Users to Excel 1 January 19th 06 09:47 PM
need to create a formula to create a timesheet but haven't a clue AHurd Excel Discussion (Misc queries) 7 August 22nd 05 12:04 PM


All times are GMT +1. The time now is 11:04 PM.

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

About Us

"It's about Microsoft Excel"