View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default How can I disable multiselection of tabs in excel

Garry,

I started with that assumption, but rereading the OP (which I've learned is
a good idea for me) they mentioned a "particular sheet":

"Hi I want to disable multi-selection of tabs in a particular worksheet in a
workbook."

Otherwise yes, they could delete the "Target.Parent" line and put in the
workbook-level event and I think it would work for all sheets.

Thanks,

Doug


"GS" wrote in message
...
Hi Doug,

Your solution works very well, but don't you mean use it in the
Workbook_SheetChange() to monitor the entire workbook?

Regards,
Garry