Reset Clear ClipBoard

YasserKhalil

Well-known Member
Joined
Jun 24, 2010
Messages
852
[FONT=&quot]Hello everyone[/FONT]
[FONT=&quot]I have searched a lot and tried a lot of codes for clearing the clipboard and this is one of them
Code:
[/FONT][/COLOR][COLOR=#2E8B57][FONT=Monaco]Public Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long[/FONT][/COLOR]
[COLOR=#2E8B57][FONT=Monaco]Public Declare Function EmptyClipboard Lib "user32" () As Long[/FONT][/COLOR]
[COLOR=#2E8B57][FONT=Monaco]Public Declare Function CloseClipboard Lib "user32" () As Long[/FONT][/COLOR]

[COLOR=#2E8B57][FONT=Monaco]Public Function ClearClipboard()[/FONT][/COLOR]
[COLOR=#2E8B57][FONT=Monaco]    OpenClipboard (0&)[/FONT][/COLOR]
[COLOR=#2E8B57][FONT=Monaco]    EmptyClipboard[/FONT][/COLOR]
[COLOR=#2E8B57][FONT=Monaco]    CloseClipboard[/FONT][/COLOR]
[COLOR=#2E8B57][FONT=Monaco]End Function[/FONT][/COLOR]

[COLOR=#2E8B57][FONT=Monaco]Sub Test()[/FONT][/COLOR]
[COLOR=#2E8B57][FONT=Monaco]    Call ClearClipboard[/FONT][/COLOR]
[COLOR=#2E8B57][FONT=Monaco]End Sub[/FONT][/COLOR][COLOR=#333333][FONT=&quot]

[/FONT]
[FONT=&quot]But nothing works for me till now[/FONT]
[FONT=&quot]Any idea?

I have posted this thread at this link
[/FONT]
http://www.eileenslounge.com/viewtopic.php?f=30&t=31849

But I didn't find a solution till now

I am using Office 2016 32 Bit
 
I don't think it is going to be possible for me to find out where the problem lies without me having a copy of office 2016 for testing.

I guess the reason for the code not working in office 2016 is that the hierarchy of the accessible buttons in the office clipboard has changed.

Regards.
 
Upvote 0

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
I don't think it is going to be possible for me to find out where the problem lies without me having a copy of office 2016 for testing.

I guess the reason for the code not working in office 2016 is that the hierarchy of the accessible buttons in the office clipboard has changed.

Regards.

Hope you one day will install this version to see the problem and tries to solve it
Thanks a lot for your great support
Best Regards
 
Upvote 0
بارك الله فيك أخي الحبيب جعفر
معلش تعبتك معايا في الموضوع دا
هل فيه إمكانية لاستخدام برنامج التيم فيور بحيث تشوف المشكلة من على جهازي ؟؟ أو هل ممكن أمشي معاك خطوات بأي برنامج بحيث تقدر تشوف هيكلة النسخة 2016؟؟
 
Upvote 0
بارك الله فيك أخي الحبيب جعفر
معلش تعبتك معايا في الموضوع دا
هل فيه إمكانية لاستخدام برنامج التيم فيور بحيث تشوف المشكلة من على جهازي ؟؟ أو هل ممكن أمشي معاك خطوات بأي برنامج بحيث تقدر تشوف هيكلة النسخة 2016؟؟

I am afraid that is not going to be possible as I have no idea about remote stuff.

If I get hold of a computer that has office 2016 installed in it, I will definitely let you know.

Regards.
 
Upvote 0

Forum statistics

Threads
1,224,802
Messages
6,181,054
Members
453,014
Latest member
Chris258

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top