Disable selection on a new workbook remotely?
 

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?

Disable selection on a new workbook remotely?
 

Hi Jon,

see chip Pearsons page on VBE programming at:

http://www.cpearson.com/excel/vbe.htm


---
Regards,
Norman


"Jon" wrote in message
ups.com...
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?