Macros n Sheet/Workbook protection

  • Thread starter Thread starter Lynne
  • Start date Start date
L

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
 
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 **
 
Back
Top