How to use Macro throughout Department
 

How about putting the macro in that same workbook.

Put a button (from the forms toolbar) on an instruction worksheet that has your
macro assigned to it.



SharonInGa wrote:

The Excel spreadsheet named "Investment Reviews" is email to several people.
Those people need to be able to click a command button which saves that
spreadsheet to their C drive and manipulates the information using the VBA
module "Sub ProcessPortfolioHoldings()

Where do I need to place the macros so that everyone in the department can
run this report independently on their PCs?

Why is this command not running the second macro?

ActiveWorkbook.RunAutoMacros xlRunPortfolioSetup

Sub ProcessPortfolioHoldings()

Workbooks.Open Filename:="C:\Investment Review.csv"

ActiveWorkbook.SaveAs Filename:="C:\PortfolioHoldings.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

''Workbooks.Open "PortfolioHoldings.XLS"

ActiveWorkbook.RunAutoMacros xlRunPortfolioSetup



--

Dave Peterson