Clear unlocked cells - Microsoft Community

hi all,

i have been using successfully following vba code in excel 2010 , 2013:

    

sub button1_click()

    on error resume next
    activesheet.usedrange = ""
    on error goto 0

end sub

this code clears unlocked cells in protected worksheet, lightning fast , never had issues code.

i moved on excel 2016 , code stopped working, doesn't clear cells , no error given.

once remove protection sheet works well, clearing cells.

i have tried different vba codes, slow down sheet 1000%

does knows issue ? can me out ?

thanks..

your code works me in excel 2016.

ensure have not got problem required sub assigned to button. insert msgbox first line of sub ensure sub called button.

Office / Excel / Other/unknown / Office 2016