Obtaining Email Address associated with Office Account

Hello!

I am looking for a VBA that can recognize the Office365 account email address associated with the user who is opening it. For example, if I open it on my computer that has my office365 account logged into it, it will recognize that I am [email protected] - but if Bob opens it on his computer it will recognize that his office365 account is [email protected].

The reason for doing this is that I want to be able to set parameters that the workbook will only show each user specified rows. Aka I only want Joe to see rows 4-10 so it hides all others when it recognizes that [email protected] is the one who opened the workbook.

It also needs to work for both macs & pcs - hence why I would like it to pull from the office365 account.

Any help is greatly appreciated!

Found this @ stackoverflow.com... don't think it'll work on macs.

Please Login or Register  to view this content.

A little simpler version...

Please Login or Register  to view this content.

I am testing on a Mac and both options you gave throw the same error related to ActiveX.
Attachment 659507

Can't help you there, never touched a Mac.