Macro Conversion Issue 2007

Hibbster

Board Regular
Joined
Feb 1, 2006
Messages
95
I have a spreadsheet in 2007 on my PC which has macros in it which all work perfectly well.

My collegues however who are all using 2007 get an error message upon opening:

"Excel was able to open the file by repairing or removing unreadable content"

"Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))"

The macros then no longer work.

I'm guessing this is just a setting somewhere that needs to be changed.

We're all a bit new to 2007. Can anyone help?
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,948
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Do they have VBA installed? (e.g. can they record and run macros?)
 

Hibbster

Board Regular
Joined
Feb 1, 2006
Messages
95
I didnt realise VBA had to be installed I thought it was already there like in 2003.

I've added the deveopler toolbar to their view but when the spreadsheet opens all the macro options are greyed out.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,948
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
All versions of Office, as I recall, had the option to not install VBA. If you did a full install of Office it should be there, but some IT departments don't seem to include it for some reason.
 

Hibbster

Board Regular
Joined
Feb 1, 2006
Messages
95

ADVERTISEMENT

I'll check. Thanks for your help
 

Hibbster

Board Regular
Joined
Feb 1, 2006
Messages
95
You were spot on.

VBA had not been installed. Simple as that.

Thanks again
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,948
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Thanks for letting us know. :)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,651
Messages
5,854,958
Members
431,689
Latest member
jacker01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top