Paste and Paste Special options are disabled

Paste and Paste Special options are disabled

Post by Abu.Surend » Fri, 28 Dec 2007 16:40:43


Guys

Can anyone advise how can i enable the paste and paste special option
in the right click menu. I ran some macros and these options got
disabled. Kindly Help
 
 
 

Paste and Paste Special options are disabled

Post by Abu.Surend » Fri, 28 Dec 2007 16:40:44

Guys

Can anyone advise how can i enable the paste and paste special option
in the right click menu. I ran some macros and these options got
disabled. Kindly Help

 
 
 

Paste and Paste Special options are disabled

Post by Abu.Surend » Fri, 28 Dec 2007 16:40:49

Guys

Can anyone advise how can i enable the paste and paste special option
in the right click menu. I ran some macros and these options got
disabled. Kindly Help
 
 
 

Paste and Paste Special options are disabled

Post by Charles Wi » Fri, 28 Dec 2007 21:11:43

Almost any macro will wipe out the clipboard. You just have to copy again
and then the paste/paste special will be enabled.


Charles
_________________________________________
FastExcel 2.3
Name Manager 4.0
http://www.yqcomputer.com/
 
 
 

Paste and Paste Special options are disabled

Post by U2hhc3V » Fri, 28 Dec 2007 22:40:00

Here is your code

Sub Enable_Buttons()

Dim oC1 As CommandBar

Set oC1 = Application.CommandBars("CELL")
oC1.Controls("&Paste").Enabled = True
oC1.Controls("Paste &Special...").Enabled = True

End Sub


Just in case you still need to disable here's the link
http://www.yqcomputer.com/
--
http://www.yqcomputer.com/