VBA on a Hidden Worksheet
 

I have recorded a macro the when run from one worksheet will perform an
advanced filter on another worksheet... allowing me to use a filterd
drop down box for a user to select from on the first sheet...It worked
great until I Hide the sheet that has the list... (I need it hidden)..
How do I get arround this...

Thank you Randy


--
RANDY IN NC
------------------------------------------------------------------------
RANDY IN NC's Profile: http://www.excelforum.com/member.php...o&userid=29778
View this thread: http://www.excelforum.com/showthread...hreadid=494898

VBA on a Hidden Worksheet
 

Randy,

if you don't want your user to see the sheet as it is temporarily unhidden
by Krabople's code, prefix the whole thing with
application.screenupdating=false.
At the end of your sub, after it's been hidden again, use
application.screenupdating = true.

Happy Christmas!

Pete





"RANDY IN NC" wrote:


I have recorded a macro the when run from one worksheet will perform an
advanced filter on another worksheet... allowing me to use a filterd
drop down box for a user to select from on the first sheet...It worked
great until I Hide the sheet that has the list... (I need it hidden)..
How do I get arround this...

Thank you Randy


--
RANDY IN NC
------------------------------------------------------------------------
RANDY IN NC's Profile: http://www.excelforum.com/member.php...o&userid=29778
View this thread: http://www.excelforum.com/showthread...hreadid=494898

VBA on a Hidden Worksheet
 

Make sure you don't select/activate any ranges.

Make sure your range references in your code are refering to that sheet.

Post your code if you have questions.

RANDY IN NC wrote:

I have recorded a macro the when run from one worksheet will perform an
advanced filter on another worksheet... allowing me to use a filterd
drop down box for a user to select from on the first sheet...It worked
great until I Hide the sheet that has the list... (I need it hidden)..
How do I get arround this...

Thank you Randy

--
RANDY IN NC
------------------------------------------------------------------------
RANDY IN NC's Profile: http://www.excelforum.com/member.php...o&userid=29778
View this thread: http://www.excelforum.com/showthread...hreadid=494898

--

Dave Peterson

VBA on a Hidden Worksheet
 

RANDY IN NC wrote:
I have recorded a macro the when run from one worksheet will perform an
advanced filter on another worksheet... allowing me to use a filterd
drop down box for a user to select from on the first sheet...It worked
great until I Hide the sheet that has the list... (I need it hidden)..
How do I get arround this...

Thank you Randy





usualy macro recorder generates

range ("ble ble ble").select
selection.xxxxx

change it to

range("ble ble ble).xxxxxx


You can't select anything on hidden sheet.