Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have multiple workbooks that have the following code:{some clean up
done so it may not be perfect} Dim theRect As Shape Dim curSheet As Worksheet Set curSheet = ActiveSheet Application.ScreenUpdating = False For Each theRect In ActiveSheet.Shapes If (theRect.Line.ForeColor.SchemeColor = 12) Then theRect.Line.ForeColor.SchemeColor = 9 End If Next When that code runs on XP/Office 2003 in a workbook that has been saved on Vista/Office 2008, I get runtime error 70, Permission denied when trying to access the schemecolor in the if statement. This code has been in the workbooks for quite a few years, but they have been recently updated(in other areas) to work correctly on Vista/Office 2008. Weird thing is that if I debug and skip the execution of the if statement, I can modify the schemecolor, and then can access the schemecolor of that rect with out issue. Has anyone else seen this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
difference between the dates ex: 4/11/2008- 7/11/2008= 3 days | Excel Worksheet Functions | |||
DOWNLOAD CRACKED 2008's SOFTWA ARCHICAD 11,UNIGRAPHICS NX5,SOLIDWORKS 2008,XSTEEL 13,AUTOCAD 2008 | Excel Programming | |||
Version Incompatibility | Excel Programming | |||
Excel 2000 and 2003 VBA and Macros Incompatibility | Excel Programming | |||
Excel 2000 v 2003 Macro & VBA Incompatibility | Excel Programming |