Excel macro help please!!!!

  Neo_0147 19:23 20 Feb 2003


Im running Office Xp. I made a spreadsheet with a number of macros on an office 2000 machine then sent it home via email. When I got home and ran the spreadsheet and tried the macro buttons they just said 'Macros in this workbook are disabled because the security level is high, and the macros have not been digitally signed or verified as safe'. I have tried lowering the security level in tools, macro, security but to no avail. Can anyone help?


  VoG™ 19:49 20 Feb 2003

If you have exited Excel after changing the security settings, then re-started Excel and it still won't work then all I can think of is to re-build the Workbook.

In the Visual Basic Editor use File/Export file to export each module, then File/Remove module to remove each module. Then save the workbook.

Re-open the workbook and use File/Import file to import each module in the VBE.

You will then need to reassign each button to the correct macro by right-clicking and selecting Assign Macro.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Inside the iMac Pro - Apple's most powerful Mac yet

iMac Pro release date, UK price & specs

Football : comment regarder la Ligue 1 en direct ?