how can I re-enable copy/paste

[taxstar]

I was testing the following methods (suggested in another thread) to disable copy/paste on a particular worksheet -- now copy and paste is disabled entirely from Excel and, apparently, from each and every excel workbook I've got. HELP!!!!!

http://www.xcelfiles.com/VBA_Quick13.html

http://www.mrexcel.com/archive2/75500/87639.htm



Taxstar

 

[taxstar]

Silly me - panicked way too soon. All I had to do was run the 'enable' macro and I'm back in business.


Taxstar

 

[ChrisCoord]

What is the enable macro?

There is a link that no longer works.

 

[taxstar]

Sorry, Chris - that was nearly 7 years ago and I don't recall what the fix was.

 

[ChrisCoord]

No worries Taxstar, I started a new thread and put the data into it in the hopoe that a VBA wizard can help. Thanks for the speedy reply

 

[AkaTrouble]

could try this

[FONT=Courier]
Application.CutCopyMode=True [/FONT]

 

[ChrisCoord]

could try this

[FONT=Courier]
Application.CutCopyMode=True [/FONT]

I created a macro with

Sub Enable_CopyPaste()
Application.CutCopyMode = True
End Sub

however it did nothing. Paste and Paste Special are still greyed out.

I have started a new thread regarding this issue http://www.mrexcel.com/forum/excel-questions/826202-disable-re-enable-copy-paste.html

 

[AkaTrouble]

might need to look at original disable code

it may say

application.cutcopypaste = false

this would need to be reversed with = true

can you post disable code you used

 

[ChrisCoord]

Hi AkaTrouble, the original code is here http://www.mrexcel.com/forum/excel-questions/826202-disable-re-enable-copy-paste.html

 

[Teeroy]

See your other thread for a solution.