Blog

Excel VBA Tips: Running macros using hyperlinks

Excel VBA Tips: Running macros using hyperlinks At work today I had to create a workbook that provided links between different sheets within a workbook and turned on a filter. However, I didn’t want to use buttons, as it would be become extremely cluttered. I discovered that you can run macros using hyperlinks, so commandbuttons…

Read More

Writing Tips – Mind Maps: Environment

Writing Tips – Mind Maps: Environment An important part of any story is the environment that it is constructed in. Without a set environment, the reader will not feel as if they are contained within the story; which will lead to them being disconnected. Ensuring that the reader is connected to your story is the…

Read More

Excel Worksheet Tips: Creating Navigation Buttons

Excel Worksheet Tips: Creating Navigation Buttons In a previous excel post, I explained how to create hyperlinks. Extending from this, you can link this ability with some simple VBA to create navigation buttons, similar to ones that you would find on websites. 1. Firstly, click on the developer tab. 2. Click on the “Insert” icon.…

Read More

Writing Tips – Mind Maps: Plot

Writing Tips – Mind Maps: Plot The plot is one of the four major pillars of a story. The plot is the evolvement of the story, the unfolding of the journey that your main protagonist(s) embark upon. The question is, what makes a good plot? What aspects do you need to cover to ensure that…

Read More

Writing Tips – Mind Maps: Story

Writing Tips – Mind Maps: Story After sitting down and thinking about how I was going to tackle creating an interesting story that others would want to read, I asked myself, what elements in a story transform an average story into a strong, moving and believable story? I sat there while ideas formed in my…

Read More