What is the difference between *Name* and *(Name) * in the Worksheet
properties.
I can define, change and goto sheets with the *name* option but cannot
seem to do the same with the *(Name) * property.
-eg. - In a new spreadsheet when I look at the Excel Objects page in
the VBA screen the three default pages are listed as Sheet(Sheet1),
Sheet2(Sheet2), Sheet3(Sheet3).
If I rename a sheet on the sheet tabs, then it is just the name in
brackets which is changed. How can I change the other name by code - I
can type it in the properties.

Thanks.


--
solotoo
------------------------------------------------------------------------
solotoo's Profile: http://www.excelforum.com/member.php...o&userid=18519
View this thread: http://www.excelforum.com/showthread...hreadid=376746