Disable "Select Sheet"

Hi,

I have a find and replace VBA formula which, when it cannot locate the specified sheet for that week, prompts the Select Sheet to popup. Is there a way for me to disable the Select Sheet popup?

Code is below:

Please Login or Register  to view this content.

you can set displayalerts to false, I think that would work:

Please Login or Register  to view this content.

Originally Posted by yudlugar

you can set displayalerts to false, I think that would work:

Please Login or Register  to view this content.

That didn't seem to work

I think I forgot to remove the underscore.

Please Login or Register  to view this content.

Hi Yudlugar,

This solution still didn't work. It keeps on displaying the Select Sheet dialogue box when it can't find the tab

Sorry, I don't know then. This method works ok for me. For example, in a new workbook, this macro:

Please Login or Register  to view this content.

displays sheet select dialog box and this macro

Please Login or Register  to view this content.

does not.

I even tried placing it just around the Channel_1 range and that still had no effect. It seems to find and replace fine until it gets to that cell and then anything beneath that in the named range doesn't get replaced.

Can you upload a workbook please and I'll take a look.

I can't upload this workbook and it'll be quite hard to replicate with data as it's linking to specific file locations

Why can't you upload it?

Just make a workbook that creates the error. It does not need to contain any real data.

Originally Posted by yudlugar

Why can't you upload it?

Just make a workbook that creates the error. It does not need to contain any real data.

Because it's a problem when it can't find the sheet in the workbook, not that it can't find the workbook. If I upload it with the links I have or any other links then when you open it, it'll bring a box up for you to open the file, not find the sheet.

So upload a workbook, where it can't find the sheet in a workbook and gives you the dialogue box, even with displayalerts set to false.

When I replicate what you have done, I do not get the dialogue box, the solution I suggested works fine - did you try what I mentioned in post #6? Do you still get the dialogue bo x then?

Originally Posted by jaslake

Hi M1234

Try this

Please Login or Register  to view this content.

No luck unfortunately it still asks me to select the sheet I'm referencing