I have some workbooks i need to protect from anyone making changes (an
thus ending up with invalid versions).

The problem is I have a combobox on them and when protected, even if
click to allow every single thing in the checkboxes, i still get a
error saying this cannot be done on a protected workbook when i clic
something in the combobox. the error highlights this line of code

Me.Range("mytables").AutoFilter 4, _
"=*" & Me.ComboBox1.Value & "*", xlAnd, , False

is it possible to get this to run? I ticked every box (including th
allow autofilter) but still this error comes up

--
Message posted from http://www.ExcelForum.com

Neo;

Can it be that your combobox is working with a range of cells which are
protected ?

Mark.
--
More Excel ? www.rosenkrantz.nl or
-------------------------------------------------------------------

"neowok " wrote in message
...
I have some workbooks i need to protect from anyone making changes (and
thus ending up with invalid versions).

The problem is I have a combobox on them and when protected, even if i
click to allow every single thing in the checkboxes, i still get an
error saying this cannot be done on a protected workbook when i click
something in the combobox. the error highlights this line of code

Me.Range("mytables").AutoFilter 4, _
"=*" & Me.ComboBox1.Value & "*", xlAnd, , False

is it possible to get this to run? I ticked every box (including the
allow autofilter) but still this error comes up.


---
Message posted from http://www.ExcelForum.com/

those cells are on the same sheet as the combobox, and the all the
tickboxes for allowing stuff in protection have been ticked for that
sheet. th other 2 sheets arent protected at all at the moment.


---
Message posted from http://www.ExcelForum.com/

In your code: Unprotect the sheet, perform your action, protect the sheet.

--
Regards,
Tom Ogilvy

"neowok " wrote in message
...
I have some workbooks i need to protect from anyone making changes (and
thus ending up with invalid versions).

The problem is I have a combobox on them and when protected, even if i
click to allow every single thing in the checkboxes, i still get an
error saying this cannot be done on a protected workbook when i click
something in the combobox. the error highlights this line of code

Me.Range("mytables").AutoFilter 4, _
"=*" & Me.ComboBox1.Value & "*", xlAnd, , False

is it possible to get this to run? I ticked every box (including the
allow autofilter) but still this error comes up.


---
Message posted from http://www.ExcelForum.com/

hmmm what code would unprotect the sheet (including entering
password)?

worksheet.unprotect(password)

--
Message posted from http://www.ExcelForum.com

worksheets("Sheet1").Unprotect Password:="ABCD"
' code
Worksheets("Sheet1").Protect Password:="ABCD"

--
Regards,
Tom Ogilvy

"neowok " wrote in message
...
hmmm what code would unprotect the sheet (including entering a
password)?

worksheet.unprotect(password) ?


---
Message posted from http://www.ExcelForum.com/