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?
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,067
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
36,067
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
36,067
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Thanks for letting us know. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,621
Members
414,082
Latest member
sasmita

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