SelectionChange disables Copy/Cut & Paste

[Sandoria]

Hi there,

I have the following code written in my worksheet SelectionChange procedure

Please Login or Register  to view this content.

"SortMe" is an ActiveX Command Button.

All my code runs fine except for one problem: I cannot do a copy/cut & paste on the worksheet with this code. It seems like every time a selection change was triggered, the CutCopyMode (aka clipboard) gets cleared.


Does anyone have any idea what I'm doing wrong here?

[Sandoria]

I've figured out that as soon as I've made adjustments to SortMe (ActiveX Command Button), the application.cutcopymode = 0 (false).

Is there anyway to avoid cutcopymode being changed by this?