Cant step into Macros

[excelhasey]

Evening all,

I am no VBA user but I have excel spreadsheets that I know run macros and when I open the spreadsheet I am met with a security warning that the macros have been disabled and I simply click Options and enable this content.

The spreadsheet then does its thing so the macros are working but I wanted to try and see if I could add a few extra things myself (gulp) by looking at the macros and trying to understand what they are doing, however when I try and View Macros the list is totally empty even if I select all open workbooks so I can't - bizarre ??

But there are macros in the spreadsheet and they do work, so why can't I see them ??

Any help please ??

[MiniBlueDragon]

Select "Visual Basic" and you should be able to see all coding in the worksheet via the left-hand VBA Projects panel.

[alrodopial]

Alt+F11