I have a workbook that was created in Excel 2003 and has a button to click on
which allows me to add photos w/captions in the report. When I open it in
Excel 2003, it works fine, but in Excel 2007, the button doesn't work. I
have enabled macros in Excel 2007. When I open the file, Excel gives me a
message stating "This workbook has lost its VBA project, ActiveX controls and
any other programmability-related features" and repairs it, but then the
photo button doesn't work.

Pl. check the 'Macro Settings' in your 'Excel Options'...

You will not have this problem if you 'Enable all macros...' which is
obviously risky.

Also chekc the option 'Trus access to the VBA...'

"RadiantDebby" wrote:

I have a workbook that was created in Excel 2003 and has a button to click on
which allows me to add photos w/captions in the report. When I open it in
Excel 2003, it works fine, but in Excel 2007, the button doesn't work. I
have enabled macros in Excel 2007. When I open the file, Excel gives me a
message stating "This workbook has lost its VBA project, ActiveX controls and
any other programmability-related features" and repairs it, but then the
photo button doesn't work.

'Macro Settings' are under the 'Trus Centre' option.

I have selected 'Disable all macros with notification' which prompts me to
enable/disable macros...

"Sheeloo" wrote:

Pl. check the 'Macro Settings' in your 'Excel Options'...

You will not have this problem if you 'Enable all macros...' which is
obviously risky.

Also chekc the option 'Trus access to the VBA...'

"RadiantDebby" wrote:

I have a workbook that was created in Excel 2003 and has a button to click on
which allows me to add photos w/captions in the report. When I open it in
Excel 2003, it works fine, but in Excel 2007, the button doesn't work. I
have enabled macros in Excel 2007. When I open the file, Excel gives me a
message stating "This workbook has lost its VBA project, ActiveX controls and
any other programmability-related features" and repairs it, but then the
photo button doesn't work.

Hi,

You might want to take a look at this article:

http://support.microsoft.com/kb/282847


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"RadiantDebby" wrote:

I have a workbook that was created in Excel 2003 and has a button to click on
which allows me to add photos w/captions in the report. When I open it in
Excel 2003, it works fine, but in Excel 2007, the button doesn't work. I
have enabled macros in Excel 2007. When I open the file, Excel gives me a
message stating "This workbook has lost its VBA project, ActiveX controls and
any other programmability-related features" and repairs it, but then the
photo button doesn't work.