Solved: Only running MyExcel.xls on named machine?

[Simon Lloyd]

Yes Ken, it seems the more i learn the more i want to learn..VBA is facinating with the flexibility and control it gives you, i got that code from Chips site, like i said i cant get it to work....but what i was intending was to either load whatever finished code we come up with or create a module in each workbook that the calls the control.xls workbook to begin the check for authorisation, workstation and username, like i said i have moved all the workbooks to one folder at the moment and left shortcuts for the users in the places that they used to be, however i have had a fair few complaint because people who have shortcuts on their desktops now cannot access the files (annoying but they will have to wait until the development of this final coding is complete!).

Getting back to the create a module i probably would have done something like

 
workbooks = E:\Analyst\Development\Admin 
For Each Workbook in Workbooks '( iknow this probably isn't the correct syntax)
    Workbook.Open
    Call AddModule
Next WorkBook

then the code from chips site would create the module and add our code to it, so that when the workbook is opened it then opens Control.xls and performs check if not authorised close all open workbooks.

Am i going to far with the coding of these workbooks?, it seems we're so close to adding the code but so far every time i try to be lazy by automating everything.

Regards,
Simon