Good afternoon,

I am working on a workbook that will be used by users of varyin
computer skills. I am creating an interface that uses forms for th
users to input required data. My concern is that while I don't allo
users to get to the excel worksheets once they have enabled the macros
all they have to do is select disable macros when the workbook firs
starts up. They could then mess up the worksheets or worse the data o
those sheets.

So I was wondering if there is a way to disable this feature for
specific workbook? If not, can anyone suggest how I can accomplis
what I am looking to do?

I was thinking of using "Protect Sheets" on close and then "Unprotec
sheets" on open but I am not sure how to do this and apply it to al
the sheets. And would it work if new sheets were imported using VBA?
Basically is there a way to apply that to everysheet in the workbook?

Thanks for any assistance!
d

--
toocol
-----------------------------------------------------------------------
toocold's Profile: http://www.excelforum.com/member.php...fo&userid=3160
View this thread: http://www.excelforum.com/showthread.php?threadid=52285