When starting the Visual Basic editor three windows pop up: the editor,
a kind of "project explorer" and a sheet properties.

1) I am curious about this "sheet properties" window appearing with the
editor. What is the purpose in a VBA programming situation?
2) Two of the sheet properties are 'Name' and '(Name)' and both are by
default designated 'Sheet1'. Apart from the fact that you can change
'Name' by clicking the tab of the sheet, what is the difference between
the two properties?
3) I have a workbook where I need an easy reference to each sheet, but
they are all given an explanatory 'Name' that is both long and
complicated and cannot be changed, so I hope to be able to use the
other. Is it possible in formulas or VBA to refer to '(Name)' in stead
of 'Name'?


NSV


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=504380