2003 file can't open macro in 2007


R

RadiantDebby

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.
 
Ad

Advertisements

S

Sheeloo

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...'
 
S

Sheeloo

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

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top