Disable selection on a new workbook remotely?

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

I need a macro that is able to prevent users from selecting cells in my
workbooks. I can accomplish this in the workbook that contains my macro
with a worksheet open event:
ThisWorkbook.Sheets("Form").EnableSelection = xlNoSelection

However, my macro is creating other workbooks that I'd like to have the
same protection on. Is there a way to place a worksheet open event for
disabling selections into a new workbook that I create?
 
Back
Top