VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,284
- Office Version
- 365
- Platform
- Windows
Hi Guys,
I have a new query on VBA Form..
I have made one timesheet tracker.
on sheet3 button placed, where user need to click to open timesheet tracker userform. (this is one time activity)
on sheet1 (besides to sheet3), all the data on userform saved in this sheet.
Everything has done...only challenge is,
This timesheet tracker workbook kept as a share workbook.
For now, there are 6 user only who will access this file.
So whenever, 1st user saves the data, it successfully save.
But exactly say..10 sec after 2nd user when try to save the data, it ask a pooped window that,
"Allow changes from mine"...this is one button.
"Allow changes from other"...this is another button.
So how do i get solution from this...Can this automatically click on --
"Allow changes from mine"...button.
Please revert...
I have a new query on VBA Form..
I have made one timesheet tracker.
on sheet3 button placed, where user need to click to open timesheet tracker userform. (this is one time activity)
on sheet1 (besides to sheet3), all the data on userform saved in this sheet.
Everything has done...only challenge is,
This timesheet tracker workbook kept as a share workbook.
For now, there are 6 user only who will access this file.
So whenever, 1st user saves the data, it successfully save.
But exactly say..10 sec after 2nd user when try to save the data, it ask a pooped window that,
"Allow changes from mine"...this is one button.
"Allow changes from other"...this is another button.
So how do i get solution from this...Can this automatically click on --
"Allow changes from mine"...button.
Please revert...
