Phil,

You could use a hidden worksheet, or used workbook names (which also can be
hidden). Not foolproof, but more secure than you currently have.

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
ups.com...
Hidden in cells to the far right of row1 are 12 variables. Some are
used to set the condition of CommanBar Controls when a worksheet event
occurs; others are displayed as a value on a worksheet properties
userform.

This worked well until recently when a user deleted row1.

I did think that any text written in the Sheet Module would be detected
when the workbook was opened if the Macro Security Level was set above
the lowest level. I was surprised to find that I could save the
workbook with a variable name and value, shCondition = "formatted" or
line number 1 = "formatted", and open the workbook without tripping the
Macro Security.

This may be completely useless, but is there perhaps a method that can
be used to read and write variables in a Sheet Module?
Thanks as always for your help
Regards
Phil