Hi ronald. Your basic approach should work. Please upload your Macro so we can examine/test it.
See How to upload your macro. Instructions for uploading to an existing post are just below the main instruction.
You may also find this Macro useful: MACRO: Upload KM Macro to New or Existing Topic @KM [Pub]