Results 1 to 2 of 2

Thread: Excel Sheet is Hidden.

  1. #1

    Thread Starter
    _______ HeSaidJoe's Avatar
    Join Date
    Jun 1999
    Location
    Canada
    Posts
    3,946

    Excel Sheet is Hidden.

    I am writing to an excel sheet behind the scenes. When I send the sheet to a user and they open it, they open excel but the sheet is for some reason hidden. Is there some code I could use in my save that would make the sheet open in normal mode when the user opens the file?

    thanks,
    "A myth is not the succession of individual images,
    but an integerated meaningful entity,
    reflecting a distinct aspect of the real world."

    ___ Adolf Jensen

  2. #2
    Frenzied Member
    Join Date
    Jul 2002
    Posts
    1,370
    Did you try:

    Code:
    Set xlBook = GetObject"whatever.xls")
    ......
    xlBook.Application.Visible = True
    xlBook.Windows(1).Visible = True
    ...................
    close & save

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width