How to change the Tables! ?
Maybe it was hidden using VBA's xlveryhidden method.
Try this macro.
Sub unhide()
Dim sh As Worksheet
For Each sh In ActiveWorkbook.Sheets
sh.Visible = True
Next sh
End Sub
Or hit Alt + F11 to open VBE......CTRL + g to open Immediate window.
Paste this in and hit <enter
Sheets("Tables").Visible = true
Gord
On Thu, 24 May 2007 15:32:01 -0700, xlsstudent
wrote:
Gord,
Appreciate your help and response. That was my first hunch. I searched for
any hidden worksheet but could not find one. I saw if the document is
protected for any changes. Nope. The document is not protected either.
Pls help.
"Gord Dibben" wrote:
Quite likely the Tables sheet is hidden.
FormatSheetUnhide and do your addition of values then re-define the reference
address to fit your new list.
Gord
On Thu, 24 May 2007 11:54:00 -0700, xlsstudent
wrote:
Thanks for all those who helped to find the data location of the list.
When I did the InsertName Define, I see the name of the list TBL_PEOPLE.
When I click on the name, it shows
=OFFSET(Tables!$D$1,1,0,COUNTA(Tables!$D:$D)-1,1)
However, I am not able to see any worksheet by name Tables. what should I do
to include few more values into this list? Pls help.
|