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

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

Similar Threads

Need Help with Macro Security 1
Menu Macro Not Executing - Need Help 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Excel file corrupted when saved or retrieved over network 2
Cannot open File on newly installed Excel 2007 1
Excel Macro-enabled Workbook 2
Building Macros in 2003 and Running in 2007 1
Loosing VBA project when opening up Excel 2007 8

Top