Protecting work

[chef]

I am hoping someone can point me in the right direction.

I have some simple code that I got help from here and it allows a user to click on a cell then it activates another sheet.
How do I stop anyone from right clicking on tab and looking//amending code.

I would also like to stop anyone being able to cut and paste my worksheet and re manipulating in manner not intended.

Also to stop them inserting rows/columns.

can you disable cut and paste and disable right click on tabs to view code?

any help appreciate and hope some of this is possible
regards
ian

 

[mrhstn]

You can lock the VBA project by going to. VB Editor >> Tools >> VBAProject Properties >> Protection then check the lock project for viewing box and enter a password.

To disable cut, copy & paste try this link

VBA Express : Excel - Disable Cut, Copy, Paste

Note: protection in Excel isn't particularly secure, it should really only be used to remind people to please don't do an action or it might break your project.

 

[chef]

hi there,
many thanks for quick response and reply.
this is really helpful and although aware not 100% secure, this will help.
have a great weekend
ian