Sorry, but that is not a simple thing to do. You cannot access the properties of a worksheet reference either programatically from the worksheet or via the automation interface in a script. The only way to this would be to write a script in the component that changes the XML of the worksheet. That is possible, but it is certainly not two lines of code. Richard