Hidden Workbook
Hidden Workbook
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Hidden Workbook

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    John G
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am using a .xls file for a database that my control routine opens up to sort or pull data. Can I make this database .xls file open as a hidden workbook and if so, how would I code it?

    John

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    In the file you want to hide click Window, Hide. When you close Excel itselt it will ask you if you want to save changes to that workbook - say yes. Then when you next open the file it'll be hidden but you'll still be able to use formulae and add/retrieve data from it. Does that do the trick?

    HTH,
    D

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com