View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff
 
Posts: n/a
Default Allow users to edit ranges for VBA objects

Problem solved!

The "cell link" in VB objects will return value to certain cells. I right
clicked those cells, selected "format cells", under "Protection" tab,
UNCHECKED the "Locked" checkbox.

Then I can protect the worksheet, and change the VB objects!