Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make opening of workbook conditional of opening of another workbook
I have a main workbook named Homebase that has a password form. The
correct password must be entered to open the Homebase workbook. Homebase has hyperlinks to module workbooks which have different names (P&L Module, Cash Flow Module, etc.) I want to make sure that users cannot open module workbooks unless the Homebase workbook is already open. If someone tried to do this a message box would appear that displays the mesage: "Sorry, but you can only access this module through Homebase." The module workbook would NOT open and Excel would be blank when the user closes the message box. Would appreciate any help with the VBA code that I would write in each module workbook to do the above. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make opening of workbook conditional of opening of another workbook
Just off the top of my head I can think of two ways, but
neither are 100% secure, it depends on what level of protection you want. One would be hide all worksheets in the module in xlveryhidden mode. Then on the workbook open event have it look to see if workbook (whatever you name the main book) is open if so unhide sheets, if not close workbook. This would mean the main workbook would always have to keep the same name. (or user could just name a workbook that name and trick it) The other would be to write to a hidden text file when it is open and then when it closes delete the file. Then the other workbook look for that when it opens. neither way is perfect but they can be modified to suit your needs. Keith www.kjtfs.com -----Original Message----- I have a main workbook named Homebase that has a password form. The correct password must be entered to open the Homebase workbook. Homebase has hyperlinks to module workbooks which have different names (P&L Module, Cash Flow Module, etc.) I want to make sure that users cannot open module workbooks unless the Homebase workbook is already open. If someone tried to do this a message box would appear that displays the mesage: "Sorry, but you can only access this module through Homebase." The module workbook would NOT open and Excel would be blank when the user closes the message box. Would appreciate any help with the VBA code that I would write in each module workbook to do the above. --- Message posted from http://www.ExcelForum.com/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make opening of workbook conditional of opening of another workbook
Would you happen to know what the VBA code would be and where I would
place it? I used the following code and cannot get it to work: Sub Workbook_Open() If Workbooks.Open("Home") = False Then ThisWorkbook.Close End If End Sub I placed the above code in ThisWorkbook. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
Conditional Formatting Using If Statement On Opening Of Workbook | Excel Worksheet Functions | |||
Question for Experts: Opening workbook with workbook references | Excel Programming |