Opening workbook and closing original wb probs
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Opening workbook and closing original wb probs

  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 have a workbook that I use as a launch pad basically. When it is run or executed it has a default screen that says "You must have macros enabled for this file to run" and the rest of the sheets are hidden and the workbook is protected. I have code on open that checks for the presence of a password and username in a separate database and if it checks out (using a predefined algorithym in the "launcher" wb) if it fail it opens a userform that asks for pass and will allow them 5 tries before closing worbook. If it passes it will open the "main" workbook and the on open code of the main wb will do the same pass check and once it does it will close the launcher wb. My problem is that is crashed every time that the "main" wb tried to call a separate wb. The thing I can't understand is that initially I had both wb's (main, launcher) so the properties wouldn't allow you to view code without pw. I unpassword protected the main file and repassword protected the main file and it started working. Is this going to be something that will work sometimes and sometimes not? Is this a worthless way of doing this?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Whats the code you use to open the seperate workbook?

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