Hi,

I have a userform which is modeless so that the user can selec
different sheets when I have the userform displayed ( I use Exce
2003). Is there a way by which I can restrict the sheets which can b
selected with the userform open? i.e say when the userform is invoke
using a button, the user should not be able to navigate to certai
sheets but be able to navigate to selected other sheets.

Thanks a lot for your time.

Regards,
Ra

--
routera
-----------------------------------------------------------------------
routeram's Profile: http://www.excelforum.com/member.php...fo&userid=1045
View this thread: http://www.excelforum.com/showthread.php?threadid=27346

hide the sheets you don't want selected or if that isn't possible use the
workbook level selectionchange event to control it.


--
Regards,
Tom Ogilyv

"routeram" wrote in message
...

Hi,

I have a userform which is modeless so that the user can select
different sheets when I have the userform displayed ( I use Excel
2003). Is there a way by which I can restrict the sheets which can be
selected with the userform open? i.e say when the userform is invoked
using a button, the user should not be able to navigate to certain
sheets but be able to navigate to selected other sheets.

Thanks a lot for your time.

Regards,
Ram


--
routeram
------------------------------------------------------------------------
routeram's Profile:
http://www.excelforum.com/member.php...o&userid=10452
View this thread: http://www.excelforum.com/showthread...hreadid=273461