Excel XLSM Workbook with VBA UserForm unable to Share with Multiple Users on Network

Hi there

We created a VBA Excel XLSM with UserForm.

The issue is unable to Share with Multiple Users on Network. So i have a vba multi user form you can download the attachment, use profile :

username: Guest
Password: Guest

or

username: Mohamedk
Password: P@ssword123

Our aim is to have this workbook on our network drive (central) and users to access this

Please review and assist or fix vb code

Regards
Shabeersa