Received .xls with macro I can't find.

B

brittonsm

I was sent an Excel file .XLS and a .XLM - So my issue is on the .XLS
file theres buttons and user forms that appear when those buttons are
clicked as well as other basic funcationality macros. BUT I can't
find the user forms or the macros. What am I missing?

-Steve
 
G

Gord Dibben

Where have you looked for the Userforms and the macros?

Alt + F11 to open Visual Basic Editor. Ctrl + r to open Project Explorer.

Expand your workbook/project. See any Forms or Modules?


Gord Dibben MS Excel MVP
 
B

B Lynn B

While it wouldn't explain the "missing" user forms - have you looked on the
sheet objects (in VBE) to see if the buttons are activex controls with code
directly on the sheet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top