How to view the source, or worksheets, in an XLSM so that it looks like just a regular Excel document?

microsoft-excel vba microsoft-excel-2013

15,994

Solution 1

Enable the developer tab in excel options. On the left side of the developer tab is visual basic click on that you see all the sheets, modules, etc within the workbook, and what they're doing.

Solution 2

Press Alt+F11

This works in every Office application and does show the VBA editor/code.

15,994

PiousVenom

Updated on September 18, 2022

Comments

PiousVenom over 1 year

I just received an XLSM file from my boss.

It's a nifty little program and all. But what I'm looking for is to see all the worksheets involved; specifically, locations where dropdown boxes are populated from.

I've never actually seen or used an XLSM, and perhaps I'm not asking the right question. But, is there a way to open this so that it looks like just a regular Excel document?
- Raystafarian almost 11 years
  
  you'll want to view the vba or visual basic through enabling the developer tab
- Raystafarian almost 11 years
  
  you can also install the explode formula auditing add-in to explode formulas
- Brian almost 11 years
  
  Holding down shift while opening most office documents stops automatic macros from running. Often code has been put in these macros to hide various elements etc.
- PiousVenom almost 11 years
  
  @Raystafarian: Thank you. Looking through that, I was able to find what I needed.