Getting data from a sheet without opening it

Hi,

I am very new to this so you will have to forgive me for asking a basic question! I want to copy and paste data from sheets without opeing them. I recorded the following macro myself:

Please Login or Register  to view this content.

I know this can be done better as it causes my workbook to flash between screens very quickly and I have much longer ones that I run too which doesn't look good. I tried deleting the 'Activate' parts hoping that this would mean the page didn't open but this didn't work. I know this has a simple solution - but I don't know how to do it!

Thanks for helping

Lara

Hi larawill .. the command you're after is:

Please Login or Register  to view this content.

But - I suggest you read the help topic and use with some caution (e.g. make sure your code won't crash and not get reset to "true" before ending.

Cheers, MM.