Thank you both i am going in favour of names instead of hide a worksheet.

Regards,
Abhilash


"okaizawa" wrote in message
...
i think Name object corresponds. as variable that belongs to a document.
Name object has a formula that returns a number, text, cell reference,
array, etc.
for instance, we can use a defined name(e.g. 'Customer')
instead of cell address(e.g. 'B2') in a formula put into a cell.

Variable Object -- Word 2003 VBA Language Reference
http://msdn.microsoft.com/library/en...HV05214028.asp

Name Object [Excel 2003 VBA Language Reference]
http://msdn.microsoft.com/library/en...HV05203124.asp

--
HTH

okaizawa


news.microsoft.com wrote:
hi,
In word object model there is Document.variables. Is there somthing
corresponding in Excel? If not can anybody tell me an alternative
approch?

Regards,
Abhilash