Forum Discussion
Userform link
Unfortunately, I cannot understand whether it is a UserForm with VBA or something else that is meant by specifying in the text.
If I may recommend, attach a file (without sensitive data) or photos and describe your request based on this file or photos.
Knowledge of the Excel version, operating system and storage medium would be an additional advantage to get a quick and accurate solution approach.
Nonetheless, here is some information that might help you.
If it isn't, please just ignore it :).
Copy a macro module to another workbook
If a workbook contains a Visual Basic for Applications (VBA) macro that you would like to use elsewhere, you can copy the module that contains that macro to another open workbook by using the Visual Basic Editor (VBE).
or with formula:
=HYPERLINK(CELL("address",Sheet1!A1))
Thank you for your patience and understanding