Does anyone know if it is possible for a user to copy a cell or range of
cells from column and then paste in the same column? I want to prevent the
users from copying a cell then pasting into another column that is formatted
differently.

Any advise would be greatly appreciated!

I think you would have to use the selection change event to manage this.
Think through what actions would be required - storing the last selection,
determining if the user had the potential to paste, unprotecting the sheet
locking all cells except the accepted column and unlocking that,
reprotecting the sheet. Plus considering what else is going on in your
sheet. Then put code to manage that in the selection change event. Also,
when you make these changes, the clipboard may be cleared, so you would need
to used your record of the last range to recopy it.

Of course if the user disables macros or disables events, your efforts would
be thwarted.

--
Regards,
Tom Ogilvy

"April" wrote in message
...
Does anyone know if it is possible for a user to copy a cell or range of
cells from column and then paste in the same column? I want to prevent
the
users from copying a cell then pasting into another column that is
formatted
differently.

Any advise would be greatly appreciated!