View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
routeram[_6_] routeram[_6_] is offline
external usenet poster
 
Posts: 1
Default displaying a dialog only over certain sheets


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