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]

Then the only solution seems to be that your buttons are not correctly assigned to the macros.
Reassign the macros and check.

 

[Zyndstoff]

Right click on button and select macro:

 

[RAJESH1960]

Right click on button and select macro:

View attachment 51607

I tried re assigning the macros, saved and closed the workbook. Later I reopened it and still it doesn't ask for permission to enable. All the other macro enabled workbooks are having the same issues now. Will try and check it out at my work place today. Will update tonight ... ?