Locking Formats

D

dale5535

Hello,

I was wondering if there was a way to lock the formats but still retai
the ability to paste into a cell. I have several employees that refus
to use the "paste special" button, so is there away around this?

Thanks
 
F

Frank Kabel

Hi
AFAIK you can't prevent copying the format when sing the 'normal' copy
and paste procedure. The only way (IMHO) would be to use the
worksheet_change event, check cells for changes and re-apply the old
formta.
But beeter: Train your users to use 'Paste Special' :)
You may create a button which automates the paste-special dialog
 
D

dale5535

Thanks,

Well really its only one employee and she knows how to "paste special
as I added the button to her tool bar. She just refuses to use it.
Other than that she is great, Oh well thanks for everyone's replies
 
Top