Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unable to get the Interior property of the range class
I get a variety of messages telling me VBA is "Unable to get [set] the
xxx property of the Range class". xxx may be Interior.Pattern or Numberformat, for example. Password protection is managed by code in this application, but at the points the problem arises, I have executed code in the immediate window to unprotect the workbook and all sheets. Plus, this works fine on 3 other machines. All four machines on which this is run have the same configuration: Excel 2003 (11.6355.6408) SP1 and XP Pro 5.1.2600 SP 2 build 2600. We also have the Framework CLR. The appliction was developed on one of the other 3 machines. This is very frustrating! Any clues would be much appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to get the Interior property of the PlotArea class | Charts and Charting in Excel | |||
Unable to set FormulaArray property of the Range class | Excel Programming | |||
unable to set the FormulaArray property of the Range class | Excel Programming | |||
Unable to set the Locked property of the range class | Excel Programming | |||
Unable to set the colorIndex Property of the Interior Class Error | Excel Programming |