Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Copy to Clipboard Failed

Hi Guys

I have written a macro which copy the objects to clipboard and paste them into Excel file.

Macro runs fine but some times it give the error Copy to Clipboard Failed .... please refer to the attach Screen Shot .

i am not running too many problems also.

I am using QV10 SR3.

please help........

3 Replies
Anonymous
Not applicable
Author

Do any of the objects have Copy/Move disabled on the Layout sheet ?

Jonathan

Not applicable
Author

It is enabled in each and every sheet object

Anonymous
Not applicable
Author

Try ticking the Document properties > Security > Macro override security checkbox.

This apparantly stops the window that pops ups when you open a document and asks if you want it to be able to access your system. Maybe this is happening behind the scenes.

Jonathan