Thread
:
Error 400 on making row visible on a protected sheet
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nick Hodge
external usenet poster
Posts: 1,173
Error 400 on making row visible on a protected 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?
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge