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