Recording Actions At Startup

[Mr_K]

Hi,

I would like to record actions taken on opening an excel workbook in vba coding. So I would like help on a code that will record any action that will be taken on opening a workbook e.g. when it asks you to update links on a workbook and you update. I want to see those actions in VBA coding.

Thanks in advance!

 

[shajueasow]

Hi,
Have you tried using your macro recorder from Tools>Macros for it?

 

[Mr_K]

Yes I have it doesn't work.

It just creates the name of the macro and a shortcut key and thats it. There is no coding it reveals.

So I thought if someone can write a code to create a macro to record actions that could help me in coming up with the kind of code I am looking for.

Thank you for your time