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


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

Is this feature not supported on the Mac?

Thanks

Richar

--
rgarber5
-----------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...fo&userid=1135
View this thread: http://www.excelforum.com/showthread.php?threadid=26348

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