How ro re-activate VBA code in macro enabled spreadsheet

[Rich_B]

One of the members on here was kind enough to write me a piece of VBA code to run in a spreadsheet I am working on. Everything was working fine until I tampered with some settings whilst trying to resolve another issue. Now the VBA code is not working. Can anyone tell me how to re-activate it?

The settings in Trust Centre are set to 'macros enabled'.

Many thanks

Rich

 

[mrmmickle1]

Just a few questions to better understand your issue:

1. Do you have a sample of the code?
2. Where was the code pasted (Personal Workbook, Workbook Module, Regular Module)?
3. How were you accessing the Macro before (From the VBE, From the Developer Tab or did it Run automatically when you opened the workbook)?
4. Has IT updated software recently.. (i.e. New version of Excel...)

 

[Rich_B]

Thank you for the response. I have now resolved the problem.

 

[mrmmickle1]

No worries. Glad you were able to resolve your issue.