Hi

you can password protect the vba project (ie the macros), press ALT & F11 to
switch to the VBE editor,
find your workbook's name in the Project Explorer (view / project explorer)
right mouse click on it
choose VBAProject Properties
Go to the protection tab
tick the check box and put a password in.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
wrote in message
...
How can I keep a user from accessing macros in a spreadsheet. I have
some of the macros run when needed via VBA, and I have other macros
that I use for such things as protecting or unprotecting all or
selected sheets as needed. But I don't want the other users to be
able to manually access the macros.
Thanks for any help.