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: 206
Default setting FaceID problem

Hi all,
i'm getting an 'object doesn't support this property or method' error when
the code runs.
it's erroring on the '.style=' line in the 'with NewMenu' section

not sure what i'm missing....

i'm using the following code to create my custom toolbar:

With Application
.ScreenUpdating = False
Arr1 = Array("Save Order", "Open Order", "Cancel Order", "Reset
Order", "Print..")
Arr2 = Array("SaveOrder", "OpenOrder", "CancelOrder", "ResetOrder",
"PrintDocuments")
Arr3 = Array(100, 101, 102, 103, 104)
Set CBAR = .CommandBars.Add("Tool Box", temporary:=True)
Set NewMenu = CBAR.Controls.Add(msoControlPopup)
With NewMenu
.Caption = "Order Tools"
.TooltipText = "Order Entry Tools"
'.Style = msoButtonIconAndCaption
'.FaceId = 100
End With
For i = 0 To UBound(Arr1)
Set MenuItm = NewMenu.Controls.Add
With MenuItm
.Caption = Arr1(i)
.Style = msoButtonIconAndCaption
.OnAction = Arr2(i)
.FaceId = Arr3(i)
.Width = widths
End With
Next
CBAR.Visible = True
DoEvents
.ScreenUpdating = True
End With

tia!

J
 
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
.FaceID Gixxer_J_97[_2_] Excel Programming 1 September 26th 05 08:43 PM
Error setting FaceId of CommandbarButton [email protected] Excel Programming 3 January 12th 05 06:10 PM
Qn: .FaceID?? Michael Vaughan Excel Programming 3 September 6th 04 02:07 PM
FaceID Toolbar (The best one ever!) Jeremy Gollehon[_2_] Excel Programming 13 June 8th 04 11:05 PM
Faceid 2003. Marc[_12_] Excel Programming 1 October 16th 03 02:52 PM


All times are GMT +1. The time now is 07:21 AM.

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"