none
Beginner VBA Question RRS feed

  • Question

  • I'm trying to teach myself how to code with VBA in Excel 2007.

    I've made a few basic macros to practice. However, everytime I open up a .xlsm file, excel will open up all of my previous projects and macros in various windows. How do I change it so that excel will only open the .xlsm file that I'm trying to open. (And I suppose how can I hide/delete all the previous macros that I only made for practice)

    For instance, will opening up "random.xlsm", the files "Practice1.xlsm", "Practice2.xlsm", "PERSONAL.xlsm", and "PERSONAL.xlsb" will open.

    Also, how do I delete a button? I've gone into Design mode with the Developer tab but I'm not sure how to proceed from here.

    And finally, are there any resources you'd recommend for learning VBA? I'm currently using homeandlearn.org and random youtube videos.

    Thank you!


    Edit: I've noticed that if I try to open up a blank excel file, all the projects open. It won't let me open a blank excel file from the desktop anymore, since it'll automatically replace the blank sheet with Practice1.xlsm and the like.
    • Edited by mattqchou Friday, June 24, 2016 6:01 PM
    Friday, June 24, 2016 5:49 PM

Answers

  • Start File Explorer (or Windows Explorer depending on your version of Windows).

    Click in the address bar, clear what's there, enter (or copy/paste)

    %appdata%\Microsoft\Excel\XLSTART

    and press Enter. If you see any workbooks there except Personal.xlsb, move them out of this folder, for example to your Documents folder.

    How to delete a button depends on what kind of button it is.

    If it's a button from the Form Controls section: right click the button, then click outside the context menu that appears, and press Delete.

    If it's a button from the ActiveX Controls section: turn on Design Mode, click once on the button to select it, then press Delete. Finally turn off Design Mode again.

    http://www.excel-easy.com/vba.html has lots of Excel VBA tutorials.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by mattqchou Friday, June 24, 2016 8:12 PM
    Friday, June 24, 2016 6:48 PM

All replies

  • Start File Explorer (or Windows Explorer depending on your version of Windows).

    Click in the address bar, clear what's there, enter (or copy/paste)

    %appdata%\Microsoft\Excel\XLSTART

    and press Enter. If you see any workbooks there except Personal.xlsb, move them out of this folder, for example to your Documents folder.

    How to delete a button depends on what kind of button it is.

    If it's a button from the Form Controls section: right click the button, then click outside the context menu that appears, and press Delete.

    If it's a button from the ActiveX Controls section: turn on Design Mode, click once on the button to select it, then press Delete. Finally turn off Design Mode again.

    http://www.excel-easy.com/vba.html has lots of Excel VBA tutorials.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by mattqchou Friday, June 24, 2016 8:12 PM
    Friday, June 24, 2016 6:48 PM
  • I want to recommend stackoverflow.

    Prepare what problem you are trying to solve

    explain what the desired outcome looks like

    and more likely you will get a good help from stackOverflow.

    I am not aware of any curriculum type learning for excel VBA. But hopefully you have a real world example or problem that you want to solve. ask the question , and i am sure someone will be able to response.

    Friday, June 24, 2016 6:53 PM
  • Thank you very much! I appreciate it
    Friday, June 24, 2016 8:12 PM