Received .xls with macro I can't find.
 

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

Received .xls with macro I can't find.
 

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

On Mon, 30 Nov 2009 12:28:32 -0800 (PST), brittonsm
wrote:

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

Received .xls with macro I can't find.
 

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?

"brittonsm" wrote:

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
.