VBA What is this macro name all about?

Can you post the code?

Please Login or Register  to view this content.

I observe that I have 3 to 4 same scenario ('Oct3-REVISE.xlsb'!........)

AND I don't know why it happened.

Originally Posted by 6StringJazzer

Oct3-REVISE.xlsb is indeed a file name, and the xlsb indicates that it's a binary workbook. I'm guessing it's being loaded at startup. If you have Windows Vista or later look in
C:\Users\<your Windows username here>\AppData\Roaming\Microsoft\Excel\XLSTART and see if the file is there. If so, it will load automatically when Excel starts.

I just open 1 workbook and that workbook named: Oct3-REVISE.xlsb

SOMETIMES, when I will [view my macros] there are 'Oct3-REVISE.xlsb'![MACRO_NAME] but SOMETIMES they are gone.

Is there something wrong with my macro or to my workbook?
My workbook: I'm using FORM CONTROL [BUTTONS] to call macro and every buttons got different macro.

Did you check that path that I suggested to see what's in it? If not do you know where Oct3-REVISE.xlsb is located? If not have you tried to search your hard drive for it?

Aside from what macros appear in the macro list, have you checked to see whether that file is loading as a hidden file?

You list several versions of Excel. Which one is this happening in?

Aside from all this, is it actually causing you any problems? I see nothing to worry about except the annoyance of having a file unintentionally open, which can be fixed. This has nothing to do with the macros you have written yourself, and shouldn't cause any problems. However, if any code actually calls this Sub, it will look for all the buttons in Sheet41, Sheet3, and Sheet2 (if they exist) in the active workbook and if their names start with btn or vbtn it will make them invisible. This reads like a very special-purpose Sub written for a specific workbook, rather than a general-purpose utility. It won't be called unintentionally by your code.

Originally Posted by 6StringJazzer

Did you check that path that I suggested to see what's in it? If not do you know where Oct3-REVISE.xlsb is located? If not have you tried to search your hard drive for it?

Aside from what macros appear in the macro list, have you checked to see whether that file is loading as a hidden file?

You list several versions of Excel. Which one is this happening in?

Aside from all this, is it actually causing you any problems? I see nothing to worry about except the annoyance of having a file unintentionally open, which can be fixed. This has nothing to do with the macros you have written yourself, and shouldn't cause any problems. However, if any code actually calls this Sub, it will look for all the buttons in Sheet41, Sheet3, and Sheet2 (if they exist) in the active workbook and if their names start with btn or vbtn it will make them invisible. This reads like a very special-purpose Sub written for a specific workbook, rather than a general-purpose utility. It won't be called unintentionally by your code.

No, I doesn't located my file on that path because my computer is not a user admin (I don't own this computer). But that file name is the one I am using right now. My workbook named. I am using MS Excel 2010 and I don't hide any of my workbook. It doesn't cause any problems at all. And yet it works fine just a little being annoyed on that name. - Thanks by the way checking my codes.

Originally Posted by tony h

When you have the file loaded in excel goto the VBA screen ALT+F11 then in the immediate window paste this :
debug.print workbooks("Oct3-REVISE.xlsb").Path and press enter

Note: if you don't see the immediate window go to the View window and select it.

Tony, after I run this debug.print workbooks("Oct3-REVISE.xlsb").Path I seen something new in View Macro tab. I don't know what next...

Do I will run this macro you've given to me WHEN I seen again this 'Oct3-REVISE.xlsb'!........ annoying macro?