Hi Everyone:

I have created a custom property very similar to the example in the help
section of excel. Now, I want to change its value, and I get an error. Can
someone show me how I can make the change.

To create the custom property (works fine):
ActiveSheet.CustomProperties.Add "cmb1", 125

To change the value ( I get the error):
ActiveSheet.CustomProperties.items(1).Value = 2000

So, for the CustomProperty named "cmb1", I want to change the value from 125
to 2000. Thanks for all your help.

Bob