VBA Error when trying to save

[RobFJ]

If I try to save an excel file using CtrlS I get a MS Visual Basic System
Error &H0004005 (-2147467259) and excel locks up. That usually means a shut
down of excel via task manager but pressing esc 10-30 times also clears it.

There is no error if I do a normal file/save using the mouse.

Problem has only just arisen with spreadsheets that have around for a couple
of years.

OS is Win7Pro 64; Office version is 2007.

Can anyone help

 

[Dave Peterson]

Just a guess...

I'm gonna bet that you have a macro that has taken over the ctrl-s shortcut key.

Try opening excel in safe mode.

Close excel
windows start button|run
type:
excel /safe
and then File|open your workbook

And test the ctrl-s shortcut key.

If that works, then it's time to look to see if there are "helpful" macros that
start when excel starts normally.

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

Essentially, you'll turn off all the addins/startup workbooks and then open
excel. And then turn on each addin (closing and reopening) one at a time to
find the culprit.

 

[RobFJ]

Hi Dave,

Excellent guess <G>

It was both the MS Conditional Sum wizard /and/ the MS Lookup wizard add-ins
that had to be disabled

Either or both would cause the error.

Thanks for the help.