Problem with protecting sheet

G

greenfalcon

I have a spreadsheet (a company timesheet) that i do not want peopl
editing the code on. I only want them to be putting in the hours tha
they have worked for the particular payperiod, it all works fine but
have one problem.

If the sheet is protected yet i have the columns unlocked where the
can type, when they do a ctrl-x (cut) and then past it somewhere else
it moves the black outlining on the cells, the problem with this i
that when they try to re-color the cells it gets a protection erro
where it wont allow them to put the outline back on the cells.

Is their a way to make it so they can not do a ctrl-x so that th
formatting can not be un-done on the cells or is their a way to make i
so that they can re-color the cells?

Thanks

Gree
 
G

Gord Dibben

green

Read the posts at this google search thread.

Jim Rech provides code to disable the copy function.

Note other posts which get around a user disabling macros when the workbook is
opened.

Gord Dibben Excel MVP
 
Top