VBA to remove all recorded except one to be linked to a print button

[DKerr]

I am preparing a work spreadsheet and would like to run a macro that will delete all macros saved in the spreadsheet including except one (as currently these macros used to build the report are still available in the View macro option). I would also like the vba code to assign to remaining macro to a button. Does anyone have such vba code?

[Solus Rankin]

You could put all macros in a PERSONAL.xlsb and not even save them in the target spreadsheet. It would remain a .xls(x) without any scripting in the VBE.

[DKerr]

This sounds complicated, I would still need one macro to remain for a print button. Do you know of an example?

[Solus Rankin]

Its not complicated. PERSONAL.xlsb is an excel spreadsheet that you can save all your macros to. If you save it in the right folder it will open 'hidden' every time you run excel. This means that no matter what spreadsheet you're currently editing you have the capability of calling any macro that you have created. All macros, including the print macro can be save here. That way the spreadsheet you're printing contains no macros at all. If you go to the macro recorder and look in the setup options, there should be an option to create a PERSONAL macro page and record to it.

If you would like to upload the scripts you have so far I could assist in creating a personal.xlsb and help you locate the proper folder to save it in. What OS are you using?

[DKerr]

Windows Server 2008 running Office 2007. Would this work as I create the report and run the macros while the spreadsheet is saved in a folder with restricted access, yet email the spreadsheet report out to over 100 colleauges most of whom would not have access to the restricted folder.