View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
oldLearner57 oldLearner57 is offline
external usenet poster
 
Posts: 119
Default hidden worksheet

hi community

can anybody guide this....

when i open a workbook, there is only 1 sheet1 display with data.
and
clicking on, example, a cell and use the Trace Dependent tool, the selected
cell has an Arrow pointing to it. The other cell with the pointer, had a
small icon (squarish shape with gridline & the arrow line is black color with
dash style & at the bottom right side, there is a small black dot)
and
i use the Formula display option, the selected cell has a formula indicating
the data was from sheet2.
however, i tried using the Format Sheet to display the sheet2, but the
command was dimmed.

is it that Sheet2 was hidden and how do i display out the hidden sheet2 ?

the workbook seems not using Macro because i went to the Macro and check,
there is nothing in the Macro dialog box??

hope my explaination is clear

thanks community for the assistance

:)



--
oldLearner57