Re: Disable Macros (97 SR2)

No.. let me clarify.

Admindb.xls is a parser. Essentially, it pulls filled in ranges of data from a series of spreadsheets. Each of these spreadsheets is exactly the same, and each contain code that executes when the sheet is opened. This code captures the username from the network and assigns this value to a specified range in the workbook:

If the workbook is subsequently opened, this opening code will by bypassed. The problem however, is that this isn't bypassed until the user opens 'thier' workbook.

What i'm looking for is a way to halt all workbook code within a workbook if i'm opening the workbook from another one. Admin DB cycles through a given directory and opens all files within that directory, pulling out only fields which have been populated with sets of data. it then saves itself as 'compiledmmdd.xls' to allow for simple review of all data up to that point.

Simply, I want the system to click 'Disable Macros' when opening another book.

Re: Disable Macros (97 SR2)

It will prevent all events from occurring until it's turned back on. I wouldn't have thought you have any actual event code that needs to run while consolidating your data but if you do, you should be able to disable events, open the new worbook, then reenable events without the workbook_open code being triggered.
Hope that helps.