I just received an e-mail from a vender which I want to replicate when
sending my final reports to cliets.

Let me try to explain how it is, and someone may help me doing the same
way or in a better way!

My vendor excel file (vendor.xls) has 4 spreadsheets (is it the right
name in english? Sorry I am brazilian), but all of them I CANNOT see.
They ARE NOT HIDDEN, as if I go to menu hide, they are not there, but I
can´t see them.

Let suppose the spreadsheets are names A, B, C & D. Spreadsheet A, has
3 boxed links named B, C & D, which are linked to the others
spreadsheets.

So if one presses B, it goes to spreadsheet B where I can see results
(numbers), but as I said, no one can see those spredsheets in the
bottom at all.

How did I find the spreadsheets? I went to menu "window - new window",
then suddenly all the 4 spreadshees appeared, with gridlines, formulas,
etc. Otherwise, I just see the linked boxed and in each spreadsheet (B,
C & D) the results.

How did he do it? How he "hide" the spreadsheets?

Thanks a lot!!!


--
Braza
------------------------------------------------------------------------
Braza's Profile: http://www.excelforum.com/member.php...o&userid=35836
View this thread: http://www.excelforum.com/showthread...hreadid=556233

Braza, me manda sua dúvida em portugues talvés seja mais fácil, mas pelo que
entendi há um código em VBA que oculta a planilha.

um abraço
Marcelo

"Braza" escreveu:


I just received an e-mail from a vender which I want to replicate when
sending my final reports to cliets.

Let me try to explain how it is, and someone may help me doing the same
way or in a better way!

My vendor excel file (vendor.xls) has 4 spreadsheets (is it the right
name in english? Sorry I am brazilian), but all of them I CANNOT see.
They ARE NOT HIDDEN, as if I go to menu hide, they are not there, but I
can´t see them.

Let suppose the spreadsheets are names A, B, C & D. Spreadsheet A, has
3 boxed links named B, C & D, which are linked to the others
spreadsheets.

So if one presses B, it goes to spreadsheet B where I can see results
(numbers), but as I said, no one can see those spredsheets in the
bottom at all.

How did I find the spreadsheets? I went to menu "window - new window",
then suddenly all the 4 spreadshees appeared, with gridlines, formulas,
etc. Otherwise, I just see the linked boxed and in each spreadsheet (B,
C & D) the results.

How did he do it? How he "hide" the spreadsheets?

Thanks a lot!!!


--
Braza
------------------------------------------------------------------------
Braza's Profile: http://www.excelforum.com/member.php...o&userid=35836
View this thread: http://www.excelforum.com/showthread...hreadid=556233

Então Marcelo, obrigado pela sua ajuda, vou tentar explicar:

Recebi uma planilha de um fornecedor, que basicamente tem 4 pastas.
Porém eu não consigo ver estas pastas, elas estão escondidas (mas não
ocultas, pois não consigo ir no "formatar - planilha - reexibir",
está desativado, como também está desativado o "Janela - reexibir"
(ainda que não é a janela toda que está escondida, somente as pastas).

O que aparece: somente 1 pasta, que tem 3 boxes linkados as outras 3
pastas. Como exemplo dei o nome para pastas A, B, C & D. Sendo que a
pasta A é a que aparece, as B, C e D estão "escondidas".

Cada vez que clica no box B, vai pra pasta B, que tem um box "menu" que
volta para pasta A, e assim por diante.

Mas ai você pode perguntar: "como você descobriu estas pastas
escondidas?" é que eu fui no "janela - nova janela" e apareceu as 4
pastas, com outra formatação, mostrando os dados etc...

Não acredito ser um VBA, mas pode ser. Talvez um comando que formata e
esconde tudo só deixando a 1a planilha aberta (as que tem os links).

Se você quiser, posso amdnar a planilha do fornecedor...

grande abraço




--
Braza
------------------------------------------------------------------------
Braza's Profile: http://www.excelforum.com/member.php...o&userid=35836
View this thread: http://www.excelforum.com/showthread...hreadid=556233