Hi,
I need your advise on the below.
I have multiple macros running which uses 4 workbooks.
1. Book1 - This has all the buttons, forms and macros
2. Book2 - 4: These are Data files - e.g. Customer Master, Product Master, Transactions Data
Book1 has various Buttons e.g. Add New Customer, Update/Delete Customer, Add New Product, Update/Delete Product, Add a Transaction, etc.
Every time a button is clicked one or more user forms are opened and macros are executed. For each button operation one or more data files are opened, the necessary changes are performed and the files are closed before the operation of that button ends.
The objective in doing so is to not allow the user to get access to the data files. However, in this process the data files get opened and closed every time a button is clicked.
Is this optimal way to write the macros?
Is there any better way to handle this process?
rgds
hemant
Bookmarks