Prevent user from selecting multiple sheets

[maacmaac]

Can I prevent a user from selecting more than one sheet at a time? I want to prevent an event in which a user may accidently select two or more sheets by mistake and then enter data that would be applied to all sheets in error.

[VBA Noob]

Try this code which goes in ThisWorkbook

http://www.contextures.com/xlvba01.html#Workbook

If a user trys to change anything when two sheets are selected it will select the active sheet

Please Login or Register  to view this content.

VBA Noob