Diabling Target Workboon Macos (if necessary)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro which searches cells of a target workbook:

For Each Cell In sh.UsedRange
'Do something
Next Cell

If this search occurs on a target workbook which has macros in the sheet
being searched (i.e. Workbook_SheetSelectionChange events or events triggered
by selecting cells), will this affect the routine? I gues I am not sure if
the routine triggers any of these events. As its a collection, I have been
assuming that this should not matter.

If it does, what can I do to avoid this from happening? Am I forced to
manually comment out code in target file? I am assuming that I cannot
disable macros as my search is also based on a macro.

Thanks

EM
 
Hi, ExcelMonkey,
You can use application.enableevents=true/false
This will suppress the execution of event macros and restart it as required.
Cheers

Pete
 

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

Change_Event troubles, no error & no work. 6
Problem with Set stmt in Workbook_SheetSelectionChange event 6
Disable Change-event macro 6
Change_Event target either of two cells 20
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Copying a value from one workbook to another 3
Highlighting The Active Cell 2
How to set up a delay to Private Sub Worksheet_Change(ByVal TargetAs Range) event 6

Back
Top