Consulting

Results 1 to 16 of 16

Thread: Open, Edit / Copy From 3 Separate Existing Macro Templates From Single Macro Template

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #10
    VBAX Contributor
    Joined
    Jul 2020
    Location
    Sun Prairie
    Posts
    127
    Location
    Quote Originally Posted by HTSCF Fareha View Post
    I appreciate the analogy Chas as I too was a Boy Scout, but to continue along that same theme, this will be used by my co-workers of which many are not too computer savvy, or to continue along the Boy Scout thing have forgotten to bring their matches.

    As described in my OP the templates I refer to are macro enabled ones.

    I have looked at building blocks and could see that they could prove useful where various bits of repetition might be recognised. However, my scenario would not fall into that bracket as each usage of the template is almost certainly going to contain totally unique content where the user would be typing their own words and selecting their own options. Occasionally some of the content on a specific document can be used again and may only require alteration in some areas. Hence the usefulness of being able to go back and re edit.

    I already have in place the three separate macro enabled templates to be able to perform these functions, but would would ideally like to be able the user to select/edit any of these three just by a click off their respective ribbon button.
    Building Blocks are much more flexible than you seem to be imagining. You can include Content Controls in them for people to fill in. If these are repurposed document property content controls, you can type something in one place in a document and have it automatically replicated in other places. Repeating Data Using Document Property Content Controls and Other Mapped Content Controls. For other mapped controls, they would have to be mapped to a point in the document template or document. Those based on the Doc Property controls work in any document and as such are suitable for global building blocks. Those based in the particular document template can likewise be used in documents based on the template. The Building Blocks Gallery Content Control can be a powerful tool.

    ----
    Switching gears, I do use hundreds of macro-enabled templates in my office and they are linked to a custom ribbon tab. That was a lot of work, a big project. It allows lower-level non-computer-savvy employees to access and use those templates. I again urge you to first explore the possibility of using building blocks.
    Here is the starting place for building a custom ribbon that can easily be transferred to multiple computers: Customize the Office Ribbon (It doesn't take rocket science) by Greg Maxey and Ribbon X download (archive) .

    KenyonFormsDocumentation.jpg
    Last edited by Chas Kenyon; 08-20-2023 at 01:54 PM. Reason: add screenshot

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •