View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Delete unprotected cells in protected worksheet

Hi,

Without a macro it's difficult but if the sheet is protected such that you
cant select locked cells then hitting tab will move between unlocked cells.

Mike

"Len Silva" wrote:

Trying to find a simple way to delete all the unprotected cells in a row of a
protected worksheet. I cannot use macros because of network security. I'm
trying to make this simple for an inexperienced user.