Stop an Auto_Open macro 2

[PBAPaul]

I have built a workbook in Excel 2000 which has an
extensive database and a list of users authorised to use
the program. The workbook has a user interface that is
started by an Autpen macro. This macro has a password
dialogue and failure to enter the password will close the
application.

I am building an installation program for this database
program and I need to add a new user name to the list in
the database program. I need to add the details to a
table of users in the database program.

How can I open the database program, using VBA, without
the Autpen macro starting?

Help!

 

[RobBroekhuis]

A very simple approach might be to check, in the auto_open sub, the application.username, and if it's you, skip out. There are more secure options, of course, but that's a way to start. Or have the workbook that's being opened check (again, in the auto_open sub) whether the workbook with the VBA code that's doing the opening (i.e., your installation workbook) is open. Presumably your users would not have this workbook.
Rob

 

[rmikesmith]

The following will work without requiring anything "artificial" be done to the target workbook:

Application.EnableEvents = False
Workbooks.Open "C:\Dirname\TargetWorkbookName.xls"
Application.EnableEvents = True

HTH
Mike

 

[RobBroekhuis]

Yes Mike, that's much cleaner
Rob

 

[Loomah]

Here's another idea

if your workbook is listed in you recently used files list you can open it from there but hold down the shift key while you do

enable macros and switch from design mode/view

RYMB

i thought that option might have disappeared but it's still there!!

happy friday
;-) If a man says something and there are no women there to hear him, is he still wrong?