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

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