fnijkampnl
New Member
- Joined
- Aug 26, 2023
- Messages
- 6
- Office Version
- 2019
- Platform
- Windows
Hi,
as it happens for a registration appl. I use a lot of macro's.
They call each other and activate or change other sheets.
Therefor I set EnavleEvents to false to start with.
And I set it to true to end the programs.
At least, that's what I think.
When another user updates the sheet, I notice that certain macro's are not started, like "Logging".
So events are still off.
How can I make it so that Data-entry is not possible when macro's are running or not properly ended?
Can the UI be blocked ie?
I can use 2 cells; one with =Now() and one filled by a macro with NOW(). And then some action at a discrepancy.
grtz Frank
as it happens for a registration appl. I use a lot of macro's.
They call each other and activate or change other sheets.
Therefor I set EnavleEvents to false to start with.
And I set it to true to end the programs.
At least, that's what I think.
When another user updates the sheet, I notice that certain macro's are not started, like "Logging".
So events are still off.
How can I make it so that Data-entry is not possible when macro's are running or not properly ended?
Can the UI be blocked ie?
I can use 2 cells; one with =Now() and one filled by a macro with NOW(). And then some action at a discrepancy.
grtz Frank