I have a workbook that I want to setup for use for multiple folks. Gonna share it in the cloud. I want people to be able to copy/paste their info from their source into my workbook, but I don't want the format of my workbook to be changed in the process. Fonts need to be my fonts, not theirs. Data needs to be in my format, not theirs.
Is there a way to do this?
Can you educate the users to use Paste Special | Values instead of just Paste (which copies in their formats as well) ?
Hope this helps.
Pete
Another option might be to have a dummy sheet for their data, then in your sheet, you just reference the dummy sheet. That way, it does not matter how they copy/paste and your formatting wont be messed with?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks