There is a user security setting that will stop your code from running
if they don't allow this type of access.

I think it's a much better idea to use that hidden sheet within the
workbook -- or even add a worksheet (that already has the code) from a
template workbook.

But there may be another option.

Can you tie into the workbook event: Workbook_SheetBeforeDoubleClick

You might need to check something to know when to continue (a key
header in a key cell or a hidden sheet level name or ???).

If the code is pretty much the same for all your sheets that need
this, it may be easier to maintain.




didn't know about the securitysetting, would've hit it for sure. It's all
GPO in this shop.

ThisWorkbook has sheethandlers : now I know

easier maintenance: I see it - and would be the way to go


thx


Ward