displaying a dialog only over certain sheets

  • Thread starter Thread starter routeram
  • Start date Start date
R

routeram

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
 
hide the sheets you don't want selected or if that isn't possible use the
workbook level selectionchange event to control it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hidden sheet bleeds through 3
How to enumerate buttons on user form 2
display $ sign in excel sheet 2
modeless userform 4
Load Userform on Workbook_Open()?? 1
Modeless dialog box appears twice on screen??? 1
Userform with commandbar popup 2
Userform with option buttons to print selected sheets 3

Back
Top