Protect the sheet, instead of the workbook:

ActiveSheet.Protect Password:= _
"pass", UserInterfaceOnly:=True

rgarber50 wrote:
I am using Excel 2004 and can't seem to get the userinterfaceonly
variant of the protect method to work. I have a protected cell on a
worksheet that I want to double click on so it runs a macro (which
toggles "Yes" and "No" in that cell) - when I do I keep getting named
argument not found - with userinterfaceonly highlighted.


ActiveWorkbook.Protect Password:= _
"pass", UserInterfaceOnly:=True

Is this feature not supported on the Mac?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html