View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo
 
Posts: n/a
Default Report to client - how to do?

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