Excuse me if this question has been answered recently. I looked but didn't
find it...

I have created a macro in VBA that contains 1 Form and 1 module that shows
the form (i.e. DataForm.show). I followed all instructions regarding
compiling, properties, saving as... But then when I run excel and load the
addin, the macro is not available to the new workbook! If I do Alt-F11 to
open the editor I see my macro there, however. Actually, there are two
projects shown...

my addin macro:
MREM (MREM.xla)

and the default:
VBAProject (Book1)

So what could be wrong? I have tried everything that I can think of.

Thank you!

Blair

Hi
in which module have you stored your macro?

-----Original Message-----
Excuse me if this question has been answered recently. I
looked but didn't
find it...

I have created a macro in VBA that contains 1 Form and 1
module that shows
the form (i.e. DataForm.show). I followed all
instructions regarding
compiling, properties, saving as... But then when I run
excel and load the
addin, the macro is not available to the new workbook! If
I do Alt-F11 to
open the editor I see my macro there, however. Actually,
there are two
projects shown...

my addin macro:
MREM (MREM.xla)

and the default:
VBAProject (Book1)

So what could be wrong? I have tried everything that I
can think of.

Thank you!

Blair


.

Well, the module is called "Module1" and its entire code is simply:

Sub MREM()
DataForm.Show
End Sub

The project workspace looks like this when I am in a brand new workbook with
the Addin loaded:

- MREM (MREM.xla)
- Microsoft Excel Objects
Sheet1 (Sheet1)
Sheet2 (Sheet2)
Sheet3 (Sheet3)
ThisWorkbook
- Forms
DataForm
- Modules
Module1

- VBAProject (Book1)
- Microsoft Excel Objects
Sheet1 (Sheet1)
Sheet2 (Sheet2)
Sheet3 (Sheet3)
ThisWorkbook

thanks,

Blair

"Frank Kabel" wrote in message
...
Hi
in which module have you stored your macro?

-----Original Message-----
Excuse me if this question has been answered recently. I
looked but didn't
find it...

I have created a macro in VBA that contains 1 Form and 1
module that shows
the form (i.e. DataForm.show). I followed all
instructions regarding
compiling, properties, saving as... But then when I run
excel and load the
addin, the macro is not available to the new workbook! If
I do Alt-F11 to
open the editor I see my macro there, however. Actually,
there are two
projects shown...

my addin macro:
MREM (MREM.xla)

and the default:
VBAProject (Book1)

So what could be wrong? I have tried everything that I
can think of.

Thank you!

Blair


.