Worksheet protection UserInterfaceOnly

[darry]

Hi all,

Another question. Suppose you have protected worksheet, and you have put UserInterfaceOnly to true (you assumed you know what you do with your VBA code)

Is it possible to switch it temporarily to False without unprotecting and protecting again the worksheet?

The idea is to construct the code a little bit like that:

DO SOMETHING TO SWITCH USERINTERFACEONLY TO FALSE
On Error Resume Next
Selection.PasteSpecial Paste:=xlPasteValues
If err<>0 Then
GIVE ERROR MESSAGE
end if
On Error Goto 0
DO SOMETHING TO SWITCH USERINTERFACEONLY TO TRUE

Thanks in advance

[BadlySpelledBuoy]

Why would you need to switch UserInterfaceOnly to False as the code will be able to paste to that sheet anyway.
UserInterfaceOnly ONLY stops the user making amendments to protected sheets, not VBA.

BSB

[darry]

Ok - I haven't shared the full context.

What we want to do is to assign to the shortcut "Ctrl+V" "Paste values" rather than "Paste". If UserInterfaceOnly is True, our "Paste values" macro pasts values also in the locked area of worksheet.
If it was possible to switch UserInterfaceOnly to False, we would get opportunity to control this type of error.

By the way - we also redefine context (right click) menu for that, with comments:

ContextMenu.Controls.Add Type:=msoControlButton, id:=19, Before:=1 ("Copy")
ContextMenu.Controls.Add Type:=msoControlButton, id:=370, Before:=2 ("Values")
ContextMenu.Controls.Add Type:=msoControlButton, id:=18063, Before:=3 ("Match destination formatting")

(where always either option 2 or 3 is available - depending on the context) and this thing works (so cells which are locked are really locked).

To get better picture of the issue - please also see my second thread: https://www.excelforum.com/excel-pro...ml#post4941435 . I think the last solution I suggested in the thread will solve our problem (I hope so).