Disable Cut,Copy and Paste Functions on Protected Worksheet

Hello,
I have a workbook that uses a Macro to protect the whole workbook at the end of the month. The problem is that even though the workbook is protected, and ALL cells are locked, you can still select 'cut' and 'copy' using the toolbar buttons, and and it will allow you to do it. It will only cut or copy the last selected cell on that worksheet, and will paste into the last selected cell on any worksheet. This is a big problem, as it means someone can actually remove the contents of the last selected cell and paste it into another, or into another workbook.
Is there a way to completely disable the cut,paste and copy toolbar buttons, right mouse click options, and keyboard shortcuts? Or alternatively is there a code to COMPLETELY protect the whole workbook that I can insert into the end of month protection macro, that will prevent any changes whatsoever? Once protected at the end of the month, the workbook only needs to be openable, readable, and printable, but that is it. No selection of cells, no formatting, nothing.
I have researched online and tried a number of different codes but none have worked in disabling the toolbar buttons.
Please help as I am on a deadline to get this workbook up and running 100%.

Regards,
Benn

Hi Jeff,
I tried that. Copied the code, and pasted into my Workbook as per the instructions. I can still cut and paste using the 'clipboard' buttons on the toolbar. I also opened the sample file attached at the link, and could do the same on that too!

Cheers,
Benn

Hi Jeff,
No I am worried that after running the end of month protection, someone still can cut,copy and paste using the clipboard buttons, and therefore can actually cut cells containing important data.

As a workaround, is there a way of including in the above code, that a specific cell is selected, say 'AH1', on each Worksheet in the Workbook. Then if someone selects 'cut or copy' and then tries to paste it, they are only cutting or copying an empty cell? I have tried this code, but can only get it to select cell AH1 on the active Worksheet. How would I rewrite it so that it selects that cell on each worksheet?

Please Login or Register  to view this content.

Regards,
Benn