Saludos Jose Luis,

I think you need to unprotect the sheet at the start, and protect it again
at the end. Look up protect and unprotect in help.

Why would you use a combobox with only one item?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jose luis" wrote
in message ...

Hello


I have a Option Button (from forms) with a Macro Attached to it that
changes the values of a combobox (also from Forms). Here is the code i
am using:



Code:
--------------------
Sub OpcionCero()
' Boton para Seleccion de Opcion Cotizacion Activa
' Macro recorded 1/5/2005 by jose luis
'
Application.ScreenUpdating = False

ActiveSheet.Shapes("Drop Down 428").Select
With Selection
.ListFillRange = "$P$2" 'Letrero Cotizacion Actual
.LinkedCell = "$L$40"
.DropDownLines = 1
.Display3DShading = True
End With

Range("A2").Select
Sheets("ADM_SYS").Range("NumeroCotizacion") = " "

Application.ScreenUpdating = True
End Sub
--------------------



My problems araise when i protect the sheet. Cause the application
crashes.

I tried with ActiveControls but i haven't been able enough to make it
run.


Any help on how to proceed will be welcomed,


Thanks in advance

Regards

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=380998