Excell Macros Series...5 - IT Skills

IT Skills

This blog is for IT lovers, accounts and finance executives who want to add value in their professional life.

test

    • Welcome to our blog. This blog is for IT lovers, Accounts/Finance Executives who wants to add value in their career path.

    Search This Blog

    Thursday, 10 May 2018

    Home Excell Macros Excell Macros Series...5

    Excell Macros Series...5

    test
    If you had chosen This Workbook as the option for storing the macro, you would need to save your workbook along with the macro.

    Try to save the workbook. By default, you would be asking Excel to save the workbook as an .xls file. Excel displays a message saying that an Excel feature VB project cannot be saved in a macro free workbook, as shown below.



    Note: If you click Yes, Excel will save your workbook as a macro free .xls file and your macro that you stored with This Workbook option will not get saved. To avoid this, Excel provides you an option to save your workbook as a macro-enabled workbook that will have .xlsm extension.

    • Click No in the warning message box.

    • Select Excel Macro-Enabled Workbook (*.xlsm) in the Save as type.

    • Click Save.



    Tags
    Author Image

    About Eagle's Eye
    Soratemplates is a blogger resources site is a provider of high quality blogger template with premium looking layout and robust design. The main mission of soratemplates is to provide the best quality blogger templates which are professionally designed and perfectlly seo optimized to deliver best result for your blog.

    By at
    Labels:
    Location: Pakistan

    No comments:

    Post a Comment

    Subscribe to: Post Comments (Atom)

    Popular

    • SQL Series...5
      Data Types Depending on their histories, different SQL implementations support a vari-ety of data types. The SQL:2003 specification re...
    • Excel Macros Series...15
      Excel Macros Series...15
      Running a Excel Macro There are several ways of executing a macro in your workbook. The macro would have been saved in your macro e...
    • VBA Programming Series...02
      Inserting a bunch of text If you often need to enter your company name, address, and phone number in your worksheets, you can crea...
    • IT Tips and Tricks Series...31
      Windows Desktop icons If you have lots of icons on your Desktop or in another folder highlight one of the icons and press the first le...
    • SQL Series...7
      SQL Series...7
      The Components of SQL SQL is a special-purpose language designed for the creation and mainte-nance of data in relational databases. Al...

    Welcome to our blog. If you want to; learn writing skills, preparation for CSS/Corporate laws, IT skills, downloading Business/IT books, and many more; this blog is for you.