I have a button which kicks off a VBA method which either hides or
unhides rows on a Worksheet.

I'd like to protect the worksheets but if I do an Error 400 occurs when
the VBA attempts to change a row's status from visible to invisible.

I've tried various protection settings but I still get the same error.

Is there one I should have tried?

Any suggestions? Should I have VBA unprotect/protect the sheet?

Use the VBA to unprotect the sheet just before unhiding and then protect
again just after

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


wrote in message
ups.com...
I have a button which kicks off a VBA method which either hides or
unhides rows on a Worksheet.

I'd like to protect the worksheets but if I do an Error 400 occurs when
the VBA attempts to change a row's status from visible to invisible.

I've tried various protection settings but I still get the same error.

Is there one I should have tried?

Any suggestions? Should I have VBA unprotect/protect the sheet?

thats what I would do


Sub Macro1()
'


ActiveSheet.Unprotect
'your code
ActiveSheet.Protect

End Sub

Unprotect the sheet
change the rows
protect the sheet

Look at the Protect and Unprotect methods of the Worksheet object.

--
Regards,
Tom Ogilvy

wrote in message
ups.com...
I have a button which kicks off a VBA method which either hides or
unhides rows on a Worksheet.

I'd like to protect the worksheets but if I do an Error 400 occurs when
the VBA attempts to change a row's status from visible to invisible.

I've tried various protection settings but I still get the same error.

Is there one I should have tried?

Any suggestions? Should I have VBA unprotect/protect the sheet?