Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This code has worked in the past for copying an oval shape with a clear background from one sheet to another. (we use it to circle info we wish to draw attention to). But it recently began to error at Activesheet.Paste. Any thoughts on why that might be? Or a way to fix, or do differently? Thanks in advance, Paul
Private Sub CommandButton2_Click() Application.ScreenUpdating = False Sheets("Sheet2").Select ActiveSheet.Shapes("Oval 2").Select Selection.Copy Sheets("Sheet1").Select ActiveSheet.unprotect ActiveSheet.Paste Selection.ShapeRange.IncrementLeft -12.75 Selection.ShapeRange.IncrementTop -30.25 Sheets("Sheet1").Select ActiveCell.Offset(0, 4).Range("A1").Select Sheets("Sheet1").Select ActiveSheet.protect DrawingObjects:=False, Contents:=True, Scenarios:=True Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Paste error | Excel Discussion (Misc queries) | |||
Error when doing a paste | Excel Programming | |||
Cut and Paste using Macro gives paste special method error | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Paste Error | Excel Programming |