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
|