Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste-special values disabled
Using Office 2003 and Windows XP;
On the Paste button drop down (standard toolbar), in certain workbooks, the "Values" option is not available. Even though I do a very basic copy of two values in one column from another workbook. Even though protection is turned off at both the sheet and workbook levels, this function is grayed out. I tried to manually turn it back on in code using: CommandBars("Standard").Controls(12).Controls(2).E nabled = True But this neither causes an error nor enables the control. What would cause this behaviour and how can I fix it? Thanks much for your assistance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste-special values disabled
For paste special to work both the workbooks must be open in the same
instance of XL. -- HTH... Jim Thomlinson "XP" wrote: Using Office 2003 and Windows XP; On the Paste button drop down (standard toolbar), in certain workbooks, the "Values" option is not available. Even though I do a very basic copy of two values in one column from another workbook. Even though protection is turned off at both the sheet and workbook levels, this function is grayed out. I tried to manually turn it back on in code using: CommandBars("Standard").Controls(12).Controls(2).E nabled = True But this neither causes an error nor enables the control. What would cause this behaviour and how can I fix it? Thanks much for your assistance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste-special values disabled
Same topic, different circumstances. One tab in my workbook used as a
look-up table. This particular tab is a very simple worksheet containing only data (and one concatenate function to pull together 3 cells for the look-up). Have been using right-click, drag, Copy here as values only with no problems until recently (the copy is occurring to the same cell, overwriting previous contents - is part of the population process). Suddenly the "Copy here as values only" function is grayed out, although I can still go through the long process of Paste SpecialValues and it works fine. Why would that option suddenly be unavailable? Thanks, Kim "Jim Thomlinson" wrote: For paste special to work both the workbooks must be open in the same instance of XL. -- HTH... Jim Thomlinson "XP" wrote: Using Office 2003 and Windows XP; On the Paste button drop down (standard toolbar), in certain workbooks, the "Values" option is not available. Even though I do a very basic copy of two values in one column from another workbook. Even though protection is turned off at both the sheet and workbook levels, this function is grayed out. I tried to manually turn it back on in code using: CommandBars("Standard").Controls(12).Controls(2).E nabled = True But this neither causes an error nor enables the control. What would cause this behaviour and how can I fix it? Thanks much for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Special Values | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
Paste special values but not... | Excel Worksheet Functions | |||
paste special values | Excel Worksheet Functions | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |