If and Then to Lock Combo Box in Excel

[njwcad]

Can anyone help

Is it possible to lock a combo - box in excel based on an if statement when a worksheet is opened

For example

On open
If A1 > 0 then lock Combo Box

Can someone advise suitable code for achieving this

Many Thanks

 

[SkipVought]

Hi,

Right click the sheet tab.

View/Project Explorer

Select the ThieWorkbook object

Click the Object dropdown and select Workbook.

Select OPEN in the Procedures drop down.

The Workbook_Open event is where you can run your code.

Skip,
[sub]
[red][/red]
[/sub]

 

[njwcad]

Skip

Thats great and many thanks - unfortunately I am an extreme novice and not sure exactly what the code should be


Thanks

 

[SkipVought]

Do you know how to lock the object?

Turn on your macro recorder and go thru the steps of doing it.

Post back with your recorded code if you need help.

Skip,
[sub]
[red][/red]
[/sub]