Disable buttons in excel

[olatzcelaya]

Hi all,

I am programming in the VBA of excel and I want to disable some buttons and cells in the excel sheet regarding the values that I introduce in other cells.Do you know how can I do this???

Thank you,

Olatz

 

[GlennUK]

How do you mean "disable cells" exactly?

With buttons I believe you change the Enabled property.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Spooku777]

The buttons are easy
btnSave.Enabled = False

To "disable" cells you have to set the Locked property for each cell and then set the sheet to be Protected.

VBA terms to use are Locked, Protect and Unprotect
Range("A1").Locked = True
Sheet1.Protect
Sheet1.Unprotect





Spook :-j