Macro to "Save As" to User's Desktop

  • Hello,
    I recorded the below macro to hide certain information in a workbook, then create a copy of that view and save it. When I recorded it, I saved it to my desktop; what I want it to do is save to the desktop of the active user.

    Is there a way to change to code below (Starting with the ActiveWorkbook.SaveAs) command to make this work for any computer?

    Thank you!

  • Re: Macro to "Save As" to User's Desktop


    Huge thanks, this worked like a charm. But, now for some reason it's not hiding the rows I need before saving the new document. My ultimate goal is to hide all rows where Column C is not MF, then do the save us function. Any thoughts?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!