View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Macksey Ken Macksey is offline
external usenet poster
 
Posts: 77
Default Protect/Unprotect Not Working

Hi

If the code is being run from a CommandButton make sure that the
TakeFocusOnClick property of the CommandButton is set to False. Also,
although I have seen it said that it is not necessary, activate the sheet
you want and select a cell on that sheet before the unprotect statement and
your problem should disappear.

Worksheets("Sheet1").activate
Range("a1").select
ActiveSheet.Unprotect

HTH

Ken