Sharing macros with other users

[Eoghan93]

Hi all,

I have a macro which will create and populate a worksheet from numerous other sheets. I want to make this available to other users on the network, to be used on a regular basis on numerous identical workbooks. What's the simplest way of achieving this?

Eoghan

[#2]

@Eoghan93 

How can I call a macro of the B.xls workbook from the A.xls workbook?

Workbook A

Public Sub test()

Application.Run ("'B.xls'!test2")

End Sub

-------------------------------------------------

Workbook B

Public Sub test2()

MsgBox "OK….it runs :-)"

End Sub

Should actually work without problems, unless it is Excel Online in the game.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

[#3]

@NikolinoDE Thanks, I'll give that a try

[#4]

If you liked it and was helped by it, please mark and vote this answer as helpful as it will be beneficial for more community members reading here.

I am happy if I could help you even a little.

Nikolino
I know I don't know anything (Socrates)