Please follow the below solution if Macro error after run vision.
Solution:-
1. Click at 'Office' Button > 'Excel Options'
2. Click 'Trust Center'
3. Click 'Trust Center Settings…'
4. Click 'Message Bar' > Tick the checkbox 'Never show information about blocked content > Tick the checkbox 'Enable Trust Center logging' > Click OK
5. Click Macro Settings > Tick the checkbox 'Enable all macro (not recommended; potentially dangerous code and run) >
Tick the checkbox 'Trust access to the VBA project object model > Click OK
6. Click OK