Disable Esc-key - macro

Y

yshridhar

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
 
D

Dave Peterson

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

Jim Cone

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
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 
Top