?
Solved

Why are my VBA macros being listed by file name in Excel?

Posted on 2015-02-24
2
Medium Priority
?
93 Views
Last Modified: 2016-02-11
After clicking the Run Macros button, I have selected the drop down "This Workbook", and some of the macros are being shown by their name only, and some are being shown with the workbook name appended to the front. Can I get rid of those appendages somehow?
0
Comment
Question by:shampouya
2 Comments
 
LVL 27

Expert Comment

by:ProfessorJimJam
ID: 40628525
they must have been stored in your personal.xlsx  which is in the XL start up folder.
0
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 40639455
Usually when you see a macro prefixed with the File name this means that your macros settings are not activating macros. or you have more than 1 workbook opened and you can see the name of the macro affected to the workbook. But as you already mentioned that you first select this workbook from the dropdown then my guess is that your macros settings are not enabled.

When you open the your workbook do you see a button OPTIONS with a security warning that macros are disabled ? if yes then simply press on Options first and enable macros then go to Run Macroes and see if the name of the workbook is still there. It should have disappeared.

gowflow
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

599 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question