Security - Protecting a paticular sheet only.

[errorX]

hello, right i have produced a spreedsheet on ms excel.
On sheet 2 is all of the information and tables etc.. for example prices and information for the combo boxes an such...i need to protect this sheet so no one can change anything on it

the problem is when i do so, and go back onto sheet 1 and say tick a checkbox or select something from the combo box is doesnt allow me to, the protection message comes up

i dont want this to come up on sheet 1, only on sheet 2!

i think its because i have links between the pages? like all of the info for the combo box is on sheet 2

I really need to know how i can do this?

please help.x

[errorX]

come on, some one must know?

[JBeaucaire]

Protecting a SHEET instead of the workbook does not result in the behavior you're describing.

If you are really protecting SHEET2 and not the whole workbook, then post it up so we can look at it and see what might be going on.

[shg]

Are the checkboxes on Sheet1 linked to cells on Sheet2? If so, those cells must be unprotected.

[errorX]

Protecting a SHEET instead of the workbook does not result in the behavior you're describing.

If you are really protecting SHEET2 and not the whole workbook, then post it up so we can look at it and see what might be going on.

i dont have it on me atm, cos its on my memory stick but i will do it 2mo if its not solved by then buttttt....

i go onto sheet 2 and protect that sheet
then when i go to sheet 1 it wont let me click on anyof the things in the combo box comes up with the message thingy

i thought it wud be cos of when u do the combobox u do a link number? right i put that on sheet 2?????

[errorX]

Are the checkboxes on Sheet1 linked to cells on Sheet2? If so, those cells must be unprotected.

Yes they are, oh ok ill try that - will i just need to change unprotect the link cell yh?

[JBeaucaire]

If you're worried a user will fiddle with sheet2 and mess up your automation, hide the sheet with a macro that makes the sheet VeryHidden. Then you won't need to protect it at all since it will be invisible.

[errorX]

yeah that would work but this is for coursework and it says something like 'so you can only chnage the prices with a password'

thanks for ur help tho ill just unprotect some of the link cells.

[ChemistB]

I'd like to see the workbook. I think, that even though you have links between the checkboxes and Sheet2, that shouldn't cause a problem unless the macro is trying to alter values on sheet2.

[errorX]

ill put it up tommorow.
i only have a macro to make a check box appear when u check another check box and it to disapper when you uncheck it.
and then 5 for option buttons