PDA

View Full Version : worksheets order + protection



choubix
05-22-2008, 02:10 AM
hello,

can someone point me in the right direction for this please? (method/functions to use...)

I would need to check, when the workbook is opened, that the worksheets are in a specific order. if not: reorganize them.

I'd like to prevent the user to delete the worksheets too.

I'd need tp protect specific cells/areas (basically I 'd like the users to be able to interact only with a selection of cells that will be used as an input for some calculations)

in short: I need to protect the environment of the user! ;)

thanks!

choubix
05-22-2008, 02:23 AM
I think I found
something relevant with "ActiveSheet.Protect UserInterfaceOnly"

using it in a workbook_open, looping through all the worksheets would allow me to protect all the worksheets from the users yet allowing them to run macros.

now I need to find: how to allow specific cells/ranges to be changed AND how to check the order/names of the workbooks (check the integrity)

Bob Phillips
05-22-2008, 02:42 AM
You could just sort the sheets at the workbook open, regardless of whether they are in oredr or not.