VBA is not working in this sheet?

[deepakbathla]

Greetings Guys...


Hello, Deepak Bathla this side n was working on VBA, when i open excel sheet after closing it.


VBA is proper working n message this showing.


"Cannot run the macro 'rnd.xlsx!MakeMeRed". The macro may not be available in this workbook or all macros may be disable.


please suggest me what should i do to able it?


Rgds

Deepak Bathla

98-912-72628

 

[Hui]

Deepak


It sounds as if the macro rnd.xlsx!MakeMeRed isn't in your file


I assume your file is called something else


Do you have access to the file: rnd.xlsx ?

If so open it and find the macro

Copy it and paste it into your file


Can you post a sample file, Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[NARAYANK991]

Hi ,


A .xlsx file cannot contain a macro ! It should be .xlsm or .xlsb


Narayan

 

[deepakbathla]

Thanks 4 it...


http://chandoo.org/wp/excel-vba/

Our First Macro - Make Me Red


M trying 2 run this macro(from upper one link) after save it but it not proper

working n message showing.


"Cannot run the macro "our-first-macro.xlsm'!MakeMeRed". The macro may not be available in this workbook or all macros may be disabled.


m not understanding....what should i do 2 run it?

please suggest it.


Rgds

Deepak Bathla