Paul3rd
12-04-2007, 10:31 AM
I placed the ForcePasteSpecial code in a workbook and it runs fine, except when that workbook is embedded as an OLE object in an Access form. Then, when a cell is Dbl Clicked the MsgBox error comes up
Error # 2147467259
Method 'Add' of object 'Command Bar Controls' failed.
After OK I can edit cell contents, but have no paste function at all.
Can anyone help me with this problem?
Thanks in Advance,
Paul3rd
Error # 2147467259
Method 'Add' of object 'Command Bar Controls' failed.
After OK I can edit cell contents, but have no paste function at all.
Can anyone help me with this problem?
Thanks in Advance,
Paul3rd