Further Development based on File existed

Hi dear all,


I would like to ask you for help on a further development based on given file. Pls see attachment.


The given file disables the function of Copy, Paste and Cut in every means: shortcuts and right options in menu.


Any possibilities to enable these three functions to some users by setting a password. The one who knows the password shall have the permission to change the content as they wish. Those who don't, still not allowed to copy, paste and cut.


Many thanks for every ideas from your side!



Cheers,
Tina

Hi,

You can still copy and paste using the ribbon. Not sure if that's something you're already dealing with.

I started to make a similar function a while ago, and I included a check for if the sheet was protected as follows:

Please Login or Register  to view this content.

I'm by no means an expert, but hopefully that helps

EDIT: To clarify. You protect the sheet and use a password, so casual users can;t unlock and the copy/paste is disabled. You unlock the sheet and you can do everything as normal.

Thanks. I expects a popup window when someone want to copy the content for example. In the popup window you have to enter the password needed.

Is it possible?