If you find yourself recreating the same macros, you can copy those macros to a special workbook called Personal.xlsb that is saved on your computer.
By default, when you create a macro in Excel, the macro works only in the workbook that contains it. This behavior is okay as long as you don’t need to use that macro in other workbooks. Any macros that you store in your personal workbook on a computer become available to you in any workbook whenever you start Excel on that same computer.
In this article


How does this work?

The personal workbook (Personal.xlsb) is opened as a hidden workbook every time you start Excel. Excel saves the personal workbook as Personal.xlsb, in the following folder on Windows 7 and Windows Vista computers:

C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART
Top of Page Top of Page

Create and update the personal workbook

To create the personal workbook, you first need to create a macro and store it in the Personal Macro Workbook. Before you get started, make sure that the Developer tab is available in the ribbon in Excel.
ShowMake the Developer tab visible in Excel 2010
  1. On the File tab, click Options, and then click Customize Ribbon
  2. Under Customize Ribbon, in the Main Tabs box, make sure that the Developer check box is selected.
  3. Click OK.
ShowMake the Developer tab visible in Excel 2007
  1. Click the Microsoft Office Button Office button image, and then click Excel Options.
  2. Click Popular, and then select the Show Developer tab in the Ribbon check box.
  3. Click OK.
Now you’re ready to record a macro and save it in the Personal Macro Workbook. In this example, you will create a simple macro by using the Macro Recorder. This macro will format the text in the current cell as bold.
  1. In cell A1, enter some text, such as “Some text.”
  2. On the Developer tab, in the Code group, click Record Macro.
    Record Macro
  3. In the Record Macro dialog box, type a name for the macro in the Macro name box, such as BoldMe. Make sure you don’t use any spaces in the name.
  4. In the Store macro in box, select Personal Macro Workbook.
    Record Macro dialog box
  5. Click OK.
  6. Press CTRL+B to apply bold formatting.
    That is only step that is recorded in the macro.
  7. On the Developer tab, in the Code group, click Stop Recording.
    Stop Recording
  8. Close any open workbooks and then exit Excel.
    A message appears that prompts you to save the changes that you made to the Personal Macro Workbook.
  9. Click Yes to save the personal workbook.
The next time you start Excel, the personal workbook is loaded but you can’t see it because it’s hidden by default. You can view Personal.xlsb by doing the following:
  1. On the View tab, in the Window group, click Unhide.
    Hide command in the Window group
    In the Unhide dialog box, you should see PERSONAL.XLSB.
  2. Click OK to view the personal workbook.
    Any macros you save to the personal workbook can be edited only by first unhiding the personal workbook. This prevents you from accidentally deleting or making unwanted changes to those macros.
  3. To hide the personal workbook, make sure you have Personal.xlsb selected, and then click Hide.
Any time you create a new macro and save it in your personal workbook or update any macros that it contains, you are prompted to save the personal workbook just as it did the first time you saved it.
Top of Page Top of Page

Best practices for saving macros

It’s not possible to share your Personal.xlsb between computers, but you can copy it to the XLSTART folder on other computers.
If you have one or just a few macros that you want to share with others, you can send them the workbook that contains it in an email message. You can also make the workbook available on a shared network drive or from a SharePoint Services library.
If you want to copy macros from the personal workbook to another workbook or vice versa, you can do so in the Project Explorer, which is in the Visual Basic Editor. You can start the Visual Basic Editor in Excel by pressing ALT+F11. For more information about copying a macro from one workbook to another, see Copy a macro module to another workbook.
Top of Page Top of Page

Introduction to the Web Design Course


Hello, and a very warm welcome to the Home and Learn computer course for Web Design. The software you need is set out below. We assume that you have absolutely no knowledge of designing web pages. Throughout the course of this book you will learn the fundamentals of Web Design. And, of course, you will start creating your own pages. By the end of the book, you will have acquired a good understanding of what web design is all about, and have the ability to take it further, if you so wish.

What you will learn

The aim of this course is to get you started designing web pages. It is assumed that you have little or no experience of the subject. During our time together, you'll learn some new concepts and ideas, most of which will not be difficult. After all, there are billions of pages on the internet, designed by the whole spectrum of humanity: children, adults, pensioners, people from all walks of life have sites out there. And if they can do it, so can you. In fact, follow the lessons carefully and you WILL do it. Before long, you'll have your own pages designed and ready to be uploaded, there for all the world to see.
The technologies you will learn are HTML, HTML5, and Cascading Style Sheets. (HTML5 is the newest version of the of the language.)
At the heart of every web page is something called HTML. You will learn what this is, and how to code it. You will also learn the newest version of HTML, which is called HTML5. Both versions are included in this course. As well as HTML, you will learn about Cascading Style Sheets, and will be able to improve the look of your web pages by adding CSS to enhance them.
At the end of most chapters in this book you will see a summary table of what you have learnt. The summary tables are also included in a separate document, called quick_reference.pdf. This is one of the files that come with this book. All the files you should have are detailed below.

What you need to do the course

The only thing you really need to do the course is a simple text editor. We explain all about this in the first chapter, Anatomy of a Web Page, in the section Software for Writing Web Pages. But the operating system you have is not important. So you can do this course on a PC or an Apple Mac.

Web Design Course Files

There are a number of files that you will need in order to complete certain sections. Whenever you need a file for a section of your course, it will be explained in the relevant section. The download location is here, under the heading Web Design - New Course (you don't need the downloads for the old course.):


Once you have all the necessary files, you can begin. The first part is all about the software you need for this course. Don't worry - you'll already have all you need, so there's nothing to buy. Click the link below for the first section.
Good luck!