cutcopymode

Hey All, Happy Friday- After a bit of googling I haven't found a way to force DisplayAlerts to stay False. According to the quote below, Excel's behavior automatically resets it to true whenever code stops executing. "If you set this property to False, Excel sets this property to True when the...

Hi I have some Calculate event code in my individual sheets to show a Click button if there's an error showing in cell K58, and if there isn't an error, then the Click button is removed. However, this means that when I'm copying and pasting, I no longer have the ability to Copy and Paste...

I'm experiencing an issue as to where I've got a SelectionChange macro set up, I can't change cells while keeping a range in CutCopyMode (I assumed this was because that code enters formula in cells, but even when it doesn't, it still cancels CutCopy). Can anyone think of a way to solve this? I...

When I have two workbooks open and running in separate instances of Excel 2010 and one has set Application.CutCopyMode to False then I am prevented from copying and pasting in the other workbook. Is there a way in VBA to use CutCopyMode or anything similar to avoid that workbook's overuse of...

Sometimes, I wonder why this particular option is not shown by intellisense though valid. Macro recorder also picks it fine. It shows the other two which I have seldom put explicitly xlCut and xlCopy!