Macros n Sheet/Workbook protection

[Lynne]

Hi everyone,
We use excel 2000.
I have setup an excel file to serve as a stationary requisition at work..
all works well.. but now i need to ensure that no one changes the format /
formulas by
error.
The sheet has 3 macros..
- to send form by mail - to be used by all
- print - to be used by all
- Update a database - for the admin dept only

If i protect the sheet... the macros will not work.. is there any way of
working around this problem...users should not have to key in passwords..
Lynne

 

[Paul B]

Lynne, You can still run a macro on this sheet when it is protected, use
something like this

ActiveSheet.Protect UserInterfaceOnly:=True


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **