Share via

Using Excel macros in embedded Excel files

Anonymous
2012-10-25T11:27:36+00:00

In OneNote 2013, we can now embed Excel worksheets, but it appears security settings prohibit me from using macros in such embedded files. I have tweaked all the Excel macro settings, but without success. Does anyone know if this is at all possible?

Thnaks,

Jan Roelof

Microsoft 365 and Office | OneNote | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-10-26T05:03:09+00:00

How do you insert the Excel worksheet? If you are inserting a blank sheet from Insert > New Excel... than that won't work because a macro enabled Excel sheet has to have xlsb extension. First create an Excel sheet with macro, then insert that.

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-10-26T13:39:16+00:00

    My problem is solved, though I don't believe I did anything different than yesterday.

    I had a macro-enabled spreadsheet with an .xlsm extension, in a SkyDrive folder. I inserted it into OneNote and everything just works.

    Bernd: I did not need to add a trusted location.

    Jan Roelof

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-10-25T13:10:40+00:00

    Did you add a new Trusted Location (notebook folder) to your Excel in

    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security\Trusted Locations\

    Bernd

    Was this answer helpful?

    0 comments