ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protect Destination Formatting (https://www.excelbanter.com/excel-programming/285971-protect-destination-formatting.html)

Bill Oertell

Protect Destination Formatting
 
Is there any way to preserve the destination formatting whenever a user
copies and pastes from another workbook?



Vasant Nanavati

Protect Destination Formatting
 
A bit complicated and probably not foolproof, but see this thread for a
creative solution:

http://google.com/groups?threadm=856...ing.google.com

--

Vasant



"Bill Oertell" wrote in message
...
Is there any way to preserve the destination formatting whenever a user
copies and pastes from another workbook?





Tom Ogilvy

Protect Destination Formatting
 
If you don't past formats, you won't change the destination format.

What do you really want to know?



--
Regards,
Tom Ogilvy

Bill Oertell wrote in message
...
Is there any way to preserve the destination formatting whenever a user
copies and pastes from another workbook?






All times are GMT +1. The time now is 03:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com