Create a user button to record a formatting macro

Hi everyone,

I have the following code which loops through all workbooks in a selected folder and applies formatting:

Please Login or Register  to view this content.

As you can see, I have everything except the actual formatting code ('Enter code to do Formatting work on all Workbooks). What I'm trying to do is have the user press a commandbutton in an existing userform which will automatically turn on the Macro Recorder so the user can applying the formatting changes, Save the new macro with a macro name already identified, and run that macro in the code listed above.

I've never done such a thing before. Any ideas? Thanks!!