I've never seen a meaningful macro run when in edit mode. So I don't think
you're going to find a macro solution.



freekrill wrote:

Hi,

I am looking for a way of disabling the close hotkey, ctrl + w.

In a previous post, it was suggested running the macro:

Application.onkey "^w", ""

would work, and it does, as long as you are not in Edit mode.

In edit mode, ctrl + w still gives you the close prompt. Is there any
way of disabling it completely?

Thanks for any help

free

--
freekrill
------------------------------------------------------------------------
freekrill's Profile: http://www.excelforum.com/member.php...fo&userid=7561
View this thread: http://www.excelforum.com/showthread...hreadid=487859

--

Dave Peterson