Screen Updating Not Completely Disabled in Excel Macro

Hi - I have an Excel macro that pulls data from Access queries, populating several different worksheets in the Excel file. I've disabled screen updating in the VBA code and that works fine...none of the operations performed in the worksheets are shown on screen. However, when I activate different worksheets in the code, the screen does show all the switching between worksheets, which is annoying and I don't want the users to see it. I thought turning off screen updating would take care of that, but I guess not. Does anyone know how to just stay on the worksheet where the user clicks the button to start the macro?

Thanks,

Jeff

You shouldn't ned to select or activate sheets

Thanks Roy,

The problem is, if I do something like

Please Login or Register  to view this content.

I get an error if I don't first select or activate the worksheet.

Thanks,

Jeff

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Added this time

What error? Post the full code or attach a workbook example

You don't appear to declare any variables.

This is wrong

Please Login or Register  to view this content.

It should be

Please Login or Register  to view this content.

Notice .Cells, not just Cells. You've used a With...End With Statement.