is this a trickie one ?? !!

[fireslguk]

i want to protect a worksheet but allow a user to enter data in specific cells but allow autofilters and macros where they click on a button to send them to a different tab. by the way some cells containing formulas are hidden

am i asking too much or not !

i couldnt see in the list to allow all users operation of macros

 

[fireslguk]

or would it be alot easier to hide the formula bar because thats what i want to acheive but only hide in this file


any one !!

 

[DominicB]

Good morning fireslguk

Are you using XL2002 or later? If so you can use protection and opt to allow filters to be used. If not, don't worry and try looking at Debra Dalgleish's site for some code to allow it.

http://www.contextures.com/xlautofilter03.html#Protect

As for the protection, you need to select all the cells that are allowed to be edited (hold down ctrl while you click to select multiple cells). Then press ctrl + 1 and go to the protection tab and ensure the locked box is unticked. This will ensure that when protection is turned on, these cells can be edited.

Finally, are you wanting to allow a macro to write to protected cells?
If so you need to use the following command before the lines which will write to cells:

ActiveSheet.Protect UserInterfaceOnly:=True

HTH

DominicB

 

[fireslguk]

thanks dom i have 2002

i can lock sheet and allow autofilters and select unlocked cells- i can do that but i want to able to click on a form button i created in this sheet which will hyperlink to another sheet in the same workbook

 

[DominicB]

Hi Fireslguk

This should work no problem with the protection set. What is the problem?

DominicB

 

[fireslguk]

dude , i worked out what im doing wrong i had the buttons on the row where autofilters were so it was picking that up instead

i inserted another row - put the buttons there and after protect

they worked


cheers anyway !!