UserInterfaceOnly on the Mac

  • Thread starter Thread starter rgarber50
  • Start date Start date
R

rgarber50

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
 
Protect the sheet, instead of the workbook:

ActiveSheet.Protect Password:= _
"pass", UserInterfaceOnly:=True
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UserInterfaceOnly not being recognised 3
Macro doesn't work when Sheets are protected UserInterfaceOnly 1
Macro doesn't work on UserInterfaceOnly-protected sheet 8
userinterfaceonly and copy method 1
Issue with UnProtect userinterfaceonly:=true 2
UserInterfaceOnly on startup 4
error using userinterfaceonly 1
Macro code mod - add tabs/apply to entire workbook 2

Back
Top