When the main macro runs it show all the process from the biggining not in the end of macro. If the next called macro (macro3) doesn't turn screenupdating off again, you will see everything it does because screenupdating is still on because of macro2.
And why the 2nd macro (in other workbook) runs perfect with or without Screenupdating =true ? If you then call another macro (macro2) that turns it back on, you will see the screen refresh at that moment.
If your code works with Conditional Formatting in Excel 2003 and earlier and the cell uses a "Formula Is" criteria with relative addressing--then you will confuse yourself terribly if you don't select the cell before investigating its conditional formatting properties. The Dir function is a convenient way of getting just the file name.
Thanks in advance TIPS FOR FINDING EXCEL SOLUTIONS 1. As the model has grown in size I have started to encounter the screen flickering as the macro jumps from one sheet to another - despite scren Updating being false and also the run time has gone from 1 minute to 4 minutes The net is awash with this problem and ideas on causes however the use of Select is commonly blamed Ignorance on my part means that I cannot alter the use of Select in my code to see if the flickering stops.I would appreciate if someone could give me guidance on how to circumvent the use of Select in this code As a web developer or IT admin, successfully managing multiple client accounts can be challenging.In chwong67's first comment, the first suggestion won't work because the workbook isn't named dest Dad XSix, One final comment: your code is written in Visual Basic for Applications (usually called VBA).VBA is the language that Excel and other Office applications use for their macros and user-defined functions.A user can select one (or more) reports in vb screen (application is written in vb 6), data from a database are processed and send to the Excel template - then unnecessary worksheets are deleted. The attached has worked very well - Excel 2010 in Windows 10 The attached sub routine loops through a list of sheets and for each sheet calls in the arguement also shown.For what it is worth, I don't display a messagebox nagging the user if they failed to choose a file.It should be obvious why nothing happens--and most users would be somewhat annoyed by the nag message.You'll be able to ask any tech support questions, or chat with the community and help others.I have several report templates (spreadsheets) in one workbook. Display Alerts=False does not work, in other words excessive worksheets are not being deleted. This is the procedure: Public Sub Remove Extra Sheets(By Ref s As String) Dim e Item As Excel.