enable macros in my file

[RAJESH1960]

Hello guys

I am facing a problem in excel sheet. I have created a few macros in my workbook. They were running fine till the last time I worked. When I opened the workbook now, it did not ask whether to enable macros and straight away opened the sheet. When I tried to run the code in the button, it displays cannot run the macro. The macro may not be available in this workbook or all macros may be disabled. I can’t understand why. What is the solution for this problem.?

 

[Zyndstoff]

what is the file extension of your workbook-file? xlsx or xlsm?

 

[RAJESH1960]

what is the file extension of your workbook-file? xlsx or xlsm?

Xlsm. I have been working on it since many days. It was working fine. Today all of a sudden the micros disabled

 

[RAJESH1960]

Xlsm. I have been working on it since many days. It was working fine. Today all of a sudden the micros disabled

If I run the code within the visual basic, where the code is written, it works. For each code I have to open and select the code to run. That is what I am able to do now.

 

[Zyndstoff]

Did you check file->options-> security, the enable macro settings?

 

[Zyndstoff]

The correct macro names assigned to the buttons? What happens when you select them via Developer->Macro->run?

 

[RAJESH1960]

Did you check file->options-> security, the enable macro settings?

You mean the trust centre settings. Yes I checked. Disable all macros with notification is checked.

 

[RAJESH1960]

The correct macro names assigned to the buttons? What happens when you select them via Developer->Macro->run?

The macro works. I opened one of my other macro enabled file. It is asking for permission to enable the macro. So I think the problem is in this sheet only. I closed and reopened the file I am working on but it is still not working.

 

[Zyndstoff]

What happens when you select the macro via Developer Tab->Macro->run?

 

[RAJESH1960]

Tim

The macro works. I opened one of my other macro enabled file. It is asking for permission to enable the macro. So I think the problem is in this sheet only. I closed and reopened the file I am working on but it is still not working

What happens when you select the macro via Developer Tab->Macro->run?

It runs the code right. Time to hit the sack. Will check again tomorrow. Thanks Zyndstoff for responding.