Disable Esc-key - macro

  • Thread starter Thread starter yshridhar
  • Start date Start date
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
 
1. look at EnableCancelKey in VBA's help.
2. Unprotect the worksheet, do the work, reprotect the worksheet
 
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
 
2. If, when protecting the worksheet you enable "edit objects" you can delete
without un-protecting the worksheet.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro-match function 5
Macro help 2
OnKey disabled by Excel at times? 4
Macro to replace in two worksheets 5
macro 2
Supress Rows Before Printing - Toolbar Icons become disable 2
User name in excel groups 3
worksheet_save macro help 5

Back
Top