get from Excel 2003 add-in to Excel 2007 add-in

[bill]

All,

OK, I know I am having a mental block, but I cannot seem to transfer
my 2003 add-in to a 2007 add-in. I opened the AddIn.xls with Excel
2007 and saved it as a .xlsm. Then when I open the .xlsm and try to
get to the VBA editor by selecting View/Macros, I see all of my
macros, but they are "dimmed out". What am I missing here?

TIA,

Bill

 

[james.billy]

All,

OK, I know I am having a mental block, but I cannot seem to transfer
my 2003 add-in to a 2007 add-in. I opened the AddIn.xls with Excel
2007 and saved it as a .xlsm. Then when I open the .xlsm and try to
get to the VBA editor by selecting View/Macros, I see all of my
macros, but they are "dimmed out". What am I missing here?

TIA,

Bill

Hi Bill,

Have you checked all your settings in the "Trust Centre"? The Trust
centre can be found by clicking on the circle in the top left, then
goto Excel Options, Trust Centre, Trust Centre Settings...

James

 

[bill]

Hi Bill,

Have you checked all your settings in the "Trust Centre"? The Trust
centre can be found by clicking on the circle in the top left, then
goto Excel Options, Trust Centre, Trust Centre Settings...

James

Hey James,

Well I checked the Trust Centre and there was nothing obvious that I
saw. Now I am wondering if perhaps I had them password protected in
Excel 2003 and that might be the problem....

Well, I just checked and indeed I have the macros password protected
in the 2003 .xls. I do remember the password, but Excel 2007 does not
prompt for it.

Any thoughts?

Bill

 

[james.billy]

Hey James,

Well I checked the Trust Centre and there was nothing obvious that I
saw. Now I am wondering if perhaps I had them password protected in
Excel 2003 and that might be the problem....

Well, I just checked and indeed I have the macros password protected
in the 2003 .xls. I do remember the password, but Excel 2007 does not
prompt for it.

Any thoughts?

Bill- Hide quoted text -

- Show quoted text -

The only thing I can suggest is this link here:

http://blogs.msdn.com/excel/archive/category/14416.aspx

It has loads of references for migrating add-ins from Excel 2003 to
2007.

James

 

[Jim Rech]

Was VBA installed with Office 2007? If you press Alt-F11 in Excel does it
open the VBE?

--
Jim
| On Nov 26, 5:16 pm, (e-mail address removed) wrote:
| >
| > > All,
| >
| > > OK, I know I am having a mental block, but I cannot seem to transfer
| > > my 2003 add-in to a 2007 add-in. I opened the AddIn.xls with Excel
| > > 2007 and saved it as a .xlsm. Then when I open the .xlsm and try to
| > > get to the VBA editor by selecting View/Macros, I see all of my
| > > macros, but they are "dimmed out". What am I missing here?
| >
| > > TIA,
| >
| > > Bill
| >
| > Hi Bill,
| >
| > Have you checked all your settings in the "Trust Centre"? The Trust
| > centre can be found by clicking on the circle in the top left, then
| > goto Excel Options, Trust Centre, Trust Centre Settings...
| >
| > James
|
|
| Hey James,
|
| Well I checked the Trust Centre and there was nothing obvious that I
| saw. Now I am wondering if perhaps I had them password protected in
| Excel 2003 and that might be the problem....
|
| Well, I just checked and indeed I have the macros password protected
| in the 2003 .xls. I do remember the password, but Excel 2007 does not
| prompt for it.
|
| Any thoughts?
|
| Bill

 

[bill]

Was VBA installed with Office 2007? If you press Alt-F11 in Excel does it
open the VBE?

--

| On Nov 26, 5:16 pm, (e-mail address removed) wrote:
| >
| > > All,
| >
| > > OK, I know I am having a mental block, but I cannot seem to transfer
| > > my 2003 add-in to a 2007 add-in. I opened the AddIn.xls with Excel
| > > 2007 and saved it as a .xlsm. Then when I open the .xlsm and try to
| > > get to the VBA editor by selecting View/Macros, I see all of my
| > > macros, but they are "dimmed out". What am I missing here?
| >
| > > TIA,
| >
| > > Bill

Jim,

BINGO! Alt F11 popped up the VBA Project Window, and clicking on the
Project prompted for the password. (I did say it was a "mental block")

Thanks,

Bill