I'm working on a spreadsheet for my employer that has a number of sheets
that need to be hidden from some users, but visible to others (e.g. costs).
All users need to be abler to make changes, but only some will see ceratin
areas.

The restricted users are mobile sales people working with laptops.

The workbook is currently set up with all sheets but one hidden and I am
using command buttons with macros to navigate in the workbook and
hide/unhide the sheets.

How can I set this so that users' are prompted for a password when they want
to access certain areas.

Thanks

DRD