I have a spreadsheet used as a timesheet to record hours worked.

By the use of 96 columns each quarter hour throughout the day can be entered.
Using 31 rows each day of the month.

For ease of view when printed, each of the cells within the area is
formatted with a thin line outside border, and this is supplemented with a
thick line border each hour.

This is the only area of the spreadsheet users are able to complete, the
rest is protected.

Within this area, Data Validation prevents users entering incorrect
information.
Additionally Conditional formatting changes the background colour of
completed quarters.

Problem: if drag and drop or copy paste is used the cell format is copied as
well as the data, and the thick hour line border is often either obliterated
or copied onto every cell.

I could use an Auto_Open macro to temporarily disable drag and drop and
copy/cut paste but this would seem overkill and make the sheet tedious to
complete when each quarter hour entry has to be made seperately.

Anyone have any code to tempoarily restrict Copy/Paste, Drag and Drop to
copying text only, effectively restricting these functions temporarily to
Edit Paste Special Value.

Many Thanks