Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with xl97 & xl2K
Hi
I have a version problem. The following script creates an icon on the toolbar. The problem is, that Excel 97 and Excel 2000 cannot handle the ..Picture property. Private Sub SetIcon(cbrCtrl As CommandBarButton, shpPict As Shape, shpMask As Shape) Dim oMask As StdPicture If Val(Application.Version) <= 9 Then shpPict.Copy cbrCtrl.PasteFace Else shpMask.CopyPicture xlScreen, xlBitmap cbrCtrl.PasteFace Set oMask = cbrCtrl.Picture shpPict.CopyPicture xlScreen, xlBitmap cbrCtrl.PasteFace cbrCtrl.Mask = oMask End If Application.CutCopyMode = False End Sub How to program this code without a compile error? Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Autosave defaults in XL2k | Setting up and Configuration of Excel | |||
Does XL2K have hard hyphens? | Excel Discussion (Misc queries) | |||
Copying autoshapes - XL2K | Excel Discussion (Misc queries) | |||
Paste columnwidths in Xl2k problem | Excel Programming | |||
Open XL2K without executing Macros | Excel Programming |