Received .xls with macro I can't find.

  • Thread starter Thread starter brittonsm
  • Start date Start date
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
 
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
 
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?
 
Back
Top