Excel VBA tips: How to Run Macros When a Workbook or Worksheet is Protected Have you created a workbook which contains macros, but you wish to protect the sheet? When you protect the sheet, it stops the macros from running, which is really annoying. However, there is a way around this. 1. Open up VBA…
Read More
IT Tips – Clearing clipboard in Word and Excel 2007 I was wondering where that option had disappeared to. After some searching, I discovered how to clear the clipboard. 1. In the office application, click the home tab. 2. On the left hand side of the bar, there will be the clipboard. Click on the…
Read More
Excel Chart Tips: Plotting With a Dynamic Range Another tip that I learnt today. When plotting a graph, the data that is to be plotted must be linked to the graph. What happens when the range of the data changes in length? You need to be able to plot using a dynamic range. 1. Specify…
Read More
Excel Worksheet Tips: Adding ticks and crosses Have you created a list and you want to tick off an item? 1. Select the cell you wish to add the tick to. 2. Change the font to “webdings” 3. To enter a tick – enter the letter a. To enter a cross – enter the letter…
Read More
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
Excel Worksheet Tips: Table from PDF to Excel At work today, I was asked if there was a way to extract the data from a table in a PDF in Adobe Reader and paste it into an excel workbook. You can, if you have the expensive adobe acrobat version; however, for the rest of us,…
Read MoreWriting 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 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 MoreWriting 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 MoreWriting 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
SUBMEG 