Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sharing macros to use in any excel file on any computer.

Status
Not open for further replies.

Adamwcz

IS-IT--Management
Dec 12, 2007
3
US
Hi.

I have created a macro for excel that puts the name of the last person to modify a document into the footer, along with the date modified.

I need to make it so everybody in the office can click a button on their toolbar to apply the macro to a document they are creating.

I have found out how to make it so I can use the button in any document on my own computer, but when I export the module as a .bas file then import it on another computer, I cannot use the macro for any documents on that computer.


I have been unsuccessfully searching the internet to figure out how to do this, and the excel help file is terrible for learning how to do things. D=
 
Not sure if this would help any, but do the other computers have their macro security set to medium or low?

Baldy McFatfat

"If at first you don't succeed, skydiving is not for you.
 
which is the same as I have my computer set, by the way. Sorry for the doublepost, I didn't know that you cannot edit posts on this forum.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top