How to log all users changes in Shared Workbook

[uberzen1]

Hi,

I have a UserForm setup that submits information to an email and then saves a log of all information to a back sheet of the shared workbook.

The issue I am having is that if 2 or more users have the sheet open at once it will only log 1 users submission in the back sheet (it come up with the "accept all mine / accept all others" Dialogue box upon closing the form).

Is there a way to add the data from all users to the log?

Any help would be greatly appreciated,

Many Thanks,
Josh

 

[dmt32]

Hi,
As a suggestion try storing your log data either in a separate workbook as a text file.

as an example:Log files using VBA in Microsoft Excel | Files, Workbook, and Worksheets in VBA

but many other suggestions out there.

Hope helpful
Dave