Macro's and Second Users?

[callumbudden]

Hello Everyone.

So I have to stylize a bunch of spreadsheet (they come as .csv and leave as worksheets) for people in my company. Then return them to them.
It is a simple, wrap text, freeze pane and align process that realistically takes a few minutes to complete however I have decided that I want them valuable minutes back each day.
I have created a macro to carry out the process for me but is there a way that I can give this macro to the users in a more easy user format than Importing it.
As if they can't wrap text, they won't be able to use any develop functions?

Any Ideas?

Callum

 

[Joe4]

Are you asking how to share your macro with other users?
There are a few options:
- Put in a workbook that they have access to
- Put it in the Personal Workbook Macro
- Put it in an Add-In and distribute that