Macro

[Benton]

There’s a call list spreadsheet we have to import from the shared drive everyday. We then have to sort, filter and do some formatting on it. We have since decided to automate it by recording a macro. One lady has been tasked with recording a macro, but now the problem is, once she has recorded the macro, when she e-mails the spreadsheet to us so we can take turns in running it. The macro is not there to be seen. She records it Personal Macro workbook. What makes it disappear?

 

[VoG]

She needs to record it in the spreadsheet you are working on, not her personal.xls.

 

[SteveO59L]

The Personal Workbook, is exactly that, "Personal".


Save the code in the distributed workbook instead.