Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi all, I have this code running in a ExclusivAccess WorkBook, but when I try to run it in a Share Workbook, pop ups a error sign saying "Can assign ListFillRange". I searched in the "Features that are unavailable in shared workbooks" but didn;t find any clue not allowing to use the code. Code: -------------------- Sheets("Impresión").Shapes("AlterUno").DrawingObje ct.ListFillRange = "$P$2" 'Letrero Cotizacion Actual Sheets("Impresión").Shapes("AlterUno").DrawingObje ct.LinkedCell = "$L$40" Sheets("Impresión").Shapes("AlterUno").DrawingObje ct.DropDownLines = 1 Sheets("Impresión").Shapes("AlterUno").DrawingObje ct.ListIndex = 1 Sheets("Impresión").Shapes("AlterUno").DrawingObje ct.Display3DShading = True -------------------- Could you give a hand with this? Should I use Active Controls instead? or is something else? Thanks in advance Jose Luis -- jose luis ------------------------------------------------------------------------ jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312 View this thread: http://www.excelforum.com/showthread...hreadid=384424 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
column widths keep changing in shared file | Excel Discussion (Misc queries) | |||
Issues with shared vs. non-shared formulas on somewhat wide spreadsheets | Excel Discussion (Misc queries) | |||
ListFill Range | Excel Discussion (Misc queries) | |||
Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
Shared document keeps changing, what can I do? | Excel Discussion (Misc queries) |