For this part of the tutorial you will need the workbook you created in part 1 (Click here to go to part 1) Once you have created your macro you may never need to make any changes or enhancements, but that’s a pretty rare case. There are only really two options for changing your macro, trashing […]
Category: Office 2003
Excel is a great application for manipulating numbers, and creating calculated results based on different sets of data. One of the most powerful and useful features of Excel is the ability to create macros, which are small ‘programs’ which repeat a pre-programmed series of commands to achieve a specific result. Associated with macros is VBA […]
Microsoft Excel contains a useful feature for allowing users to add a comment to a spreadsheet cell, which can be used to provide instructions to other people who may use the sheet. Cells with comments are denoted with a small red triangle in the top right corner, which then displays the comments box when the […]
If you develop solutions for other people using Excel as platform you will almost certainly have been in a situation where a user has (accidentally?) managed to mess things up by trying to change something they shouldn’t. In all good software solutions, the users should only be able to edit the parts they need to, […]
It doesn’t take most regular Excel users very long to get used to the alphanumeric referencing system for cells such A4, C8, BA27 etc, and this is fine when constructing fairly small and simple spreadsheets. However once workbooks and their worksheets become larger than just a few cells, trying to remember which number was in […]
Microsoft Excel has two types of cell reference – Absolute and Relative, and an understanding of how these references differ and work can help the spreadsheet designer to save vast amounts time when compiling their spreadsheet, especially when they are copying formulae or worksheets around a workbook. To best describe the difference between the two […]
Adding accented characters into your Excel workbook is commonly achieved by using the Insert –> Symbol menu options to select the character you want, however while this is fine for inserting the odd symbol every now and again, if you have to enter lots of different symbols then things can become very tedious indeed. Fortunately Microsoft have provided a […]
Microsoft Excel provides a very handy function called the ‘Info’ function which allows Workbook designers to give users various system information without a lot delving around in VBA etc. For this demonstration we will use the Info function to enter the directory path of the current workbook into a cell. Firstly you will need to […]