Locking Formats

  • Thread starter Thread starter dale5535
  • Start date Start date
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
 
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
 
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
 
Back
Top