Can I change the default paste options?
I'm using Microsoft Excell 2003 from Office 2003 Professional. What I'm
trying to do is copy and paste numbers from a statistics table online into my open workbook. Now I can enable and disable the "paste options" button that appears when I paste the number. from the button the options are to "Keep source formatting" or "Match Destination Formatting". The default is to "keep source formatting" and that wont show up in the workbook correctly. What I want to know is can I change any options so that no matter what I copy and paste it will match the formatting of my workbook by default and give me the choice to keep source formatting as an option instead of vis-versa. |
Can I change the default paste options?
Charlie
You cannot add to the smart tags options or alter the default. At least through the User Interface or VBA -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk "Charlie B" <Charlie wrote in message ... I'm using Microsoft Excell 2003 from Office 2003 Professional. What I'm trying to do is copy and paste numbers from a statistics table online into my open workbook. Now I can enable and disable the "paste options" button that appears when I paste the number. from the button the options are to "Keep source formatting" or "Match Destination Formatting". The default is to "keep source formatting" and that wont show up in the workbook correctly. What I want to know is can I change any options so that no matter what I copy and paste it will match the formatting of my workbook by default and give me the choice to keep source formatting as an option instead of vis-versa. |
All times are GMT +1. The time now is 11:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com