Maybe you can make the file read-only with a note that
macros must be enabled to write to the sheet. When the
macro is initiated, it can disable read only then protect
the columns.

Another way is to have the file on your computer so other
users have to network the file for access.

Or if there is only one computer, use Administration
rights to adjust the settings in the toolbars. Remove the
enable/disable macro toolbar setting altogether so it is
not present. This way there is no option.



There is a way to do what you want but it is a secret and
I don't know what it is.

-----Original Message-----
i hv a code which protects selected columns according to
users' login name,
so that unautorized user can't edit on columns on which
he is not supposed
to.
there is a problem, user has to "enable" macro when he
opens the workbook.
If he disable the macro, then the whole protection dies
as there is no macro
to run to check login name and authorization.
anybody can advice?


.