PDA

View Full Version : Solved: Working on a not visible Worksheet



pepe90
07-21-2011, 09:47 AM
Hello, does anybody knows if there is the way to activate or select a sheet with VBA without making it visible to the user?

Bob Phillips
07-21-2011, 10:03 AM
You neither need to activate it nor select it. Just reference cells on that sheet via the worksheet object, without selecting.