Unable to record

mesteptoe · Apr 27, 2015

I have generated a lot of workbooks which enable management of some engineering projects. The workbooks include many spreadsheets which assist Project Managers with control of their project, eg. Programming, Financial control, Briefs and Responses, Projects Notes, Safety Audits etc. etc. Each workbook contains lots of macros to assist in moving around the workbook, saving and exiting etc. Each workbook contains a MENU spreadsheet which includes lots of MACRO buttons to take you to the other spreadsheets.

In one particular workbook pressing a button in the MENU spreadsheet caused Excel to crash and exit. I have deleted the macro recorded to that button. I've then tried to re-record the macro using the same button but, just in case, have changed it's name. However I now get the message "Unable to record". I've tried deleting the button entirely and inserted a new button from the Developer - Insert Menus. However, when I try to record the macro I get the same "Unable to record message".

Any suggestions much appreciated.

Graham

Michael M · Apr 27, 2015

Has somebody disabled macros in the workbook trust center ?

Have also you tried

Code:

Use the Detect and Repair Command

1. Start Excel.
2. On the Help menu, click Detect and Repair
3. Click Start.

mesteptoe · Apr 27, 2015

Michael M said:
Has somebody disabled macros in the workbook trust center ?

Have also you tried

Code:

Use the Detect and Repair Command 1. Start Excel. 2. On the Help menu, click Detect and Repair 3. Click Start.

Hi, thanks for reply. No the macros have not been disabled. The other macros work in this workbook in any case.

Not sure where to find the Detect and Repair Command.

Graham

mesteptoe · Apr 27, 2015

[FONT=&quot]When Excel first crashed the following reasons were given,

Problem signature:[/FONT]

[FONT=&quot] Problem Event Name: APPCRASH[/FONT]
[FONT=&quot] Application Name: EXCEL.EXE[/FONT]
[FONT=&quot] Application Version: 14.0.7147.5000[/FONT]
[FONT=&quot] Application Timestamp: 550f3d44[/FONT]
[FONT=&quot] Fault Module Name: VBE7.DLL[/FONT]
[FONT=&quot] Fault Module Version: 7.0.16.28[/FONT]
[FONT=&quot] Fault Module Timestamp: 506f83c8[/FONT]
[FONT=&quot] Exception Code: c0000005[/FONT]
[FONT=&quot] Exception Offset: 00208764[/FONT]
[FONT=&quot] OS Version: 6.1.7601.2.1.0.18.10[/FONT]
[FONT=&quot] Locale ID: 2057[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Additional information about the problem:[/FONT]
[FONT=&quot] LCID: 1033[/FONT]
[FONT=&quot] skulcid: 1033[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Read our privacy statement online:[/FONT]
[FONT=&quot] [/FONT][FONT=&quot]http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409[/FONT][FONT=&quot][/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]If the online privacy statement is not available, please read our privacy statement offline:[/FONT]
[FONT=&quot] [/FONT][FONT=&quot]C:\Windows\system32\en-US\erofflps.txt[/FONT][FONT=&quot][/FONT]

Michael M · Apr 27, 2015

I've never seen that error message before, so can't help there !!

But read this

Excel crashes in VBE7.DLL running or enabling macro - The Microsoft Excel Support Team Blog - Site Home - TechNet Blogs

Unable to record

mesteptoe

Board Regular

Excel Facts

Michael M

Well-known Member

mesteptoe

Board Regular

mesteptoe

Board Regular

Michael M

Well-known Member

Similar threads

Forum statistics

Share this page

Unable to record

mesteptoe

Board Regular

Excel Facts

Michael M

Well-known Member

mesteptoe

Board Regular

mesteptoe

Board Regular

Michael M

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock