i have set up a macro to open a workbook and put some information into it.
i would like to see it up so that when the macro tries to open the book if another user already has the workbook open a message is shown to the user saying that they cannot enter the data at the moment.
in addition how do i stop messages being shown to the user eg do you wish to save changes etc
finally, there is no way presumably to automatically activate macros on the workbook being opened by vba code but can the macros be disabled?
thanks for your help
i would like to see it up so that when the macro tries to open the book if another user already has the workbook open a message is shown to the user saying that they cannot enter the data at the moment.
in addition how do i stop messages being shown to the user eg do you wish to save changes etc
finally, there is no way presumably to automatically activate macros on the workbook being opened by vba code but can the macros be disabled?
thanks for your help