Disable Esc-key - macro
 

hello Everybody
1. How to disable Esc-key while a macro is running?

2. How to delete comments in a protected worksheet using macro?

With regards
Sreedhar

Disable Esc-key - macro
 

1. look at EnableCancelKey in VBA's help.
2. Unprotect the worksheet, do the work, reprotect the worksheet

yshridhar wrote:

hello Everybody
1. How to disable Esc-key while a macro is running?

2. How to delete comments in a protected worksheet using macro?

With regards
Sreedhar

--

Dave Peterson

Disable Esc-key - macro
 

Sreedhar,
Re 1: Review the help file on the EnableCancelKey property.
Re 2: Unprotect the worksheet, delete, protect the worksheet.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"yshridhar"
wrote in message
hello Everybody
1. How to disable Esc-key while a macro is running?
2. How to delete comments in a protected worksheet using macro?
With regards
Sreedhar

Disable Esc-key - macro
 

2. If, when protecting the worksheet you enable "edit objects" you can delete
without un-protecting the worksheet.


Gord Dibben MS Excel MVP

On Fri, 8 Feb 2008 00:32:00 -0800, yshridhar
wrote:

hello Everybody
1. How to disable Esc-key while a macro is running?

2. How to delete comments in a protected worksheet using macro?

With regards
Sreedhar

Disable Esc-key - macro
 

Thaks Gord and Dave. I got it.
With regards
Sreedhar

"Gord Dibben" wrote:

2. If, when protecting the worksheet you enable "edit objects" you can delete
without un-protecting the worksheet.


Gord Dibben MS Excel MVP

On Fri, 8 Feb 2008 00:32:00 -0800, yshridhar
wrote:

hello Everybody
1. How to disable Esc-key while a macro is running?

2. How to delete comments in a protected worksheet using macro?

With regards
Sreedhar