In MS Excel how can i hide rows using a macro that are protected?

Question

I want to use a macro to hide and another to unhide rows in ms excel. But i also want to protect the sheet. The macro can't hide/unhide the protected rows. Is ther any way i can achive the level of protection for these rows and still have macros able to hide/unhide them?

Answer 1

Simple, write your macro to unprotect, hide, protect to hide rows
and unprotect, unhide, protect to unhide rows

Answer 2

The Macro Recorder is a good way to learn how to do stuff. I'm sure you know how to protect and unprotect your worksheet and you also know how to hide and unhide rows. Just run the Macro Recorder as you protect and unprotect the worksheet and hide and unhide the rows. Then you can just go back and modify the code a little so that it runs more efficiently and does what you want.

The macro can work with the rows, but you just have to do a little thinking when you write/record the macro. Unprotect the worksheet first, make the row changes, then reprotect the worksheet with the macro before the it finishes.

Answer 3

A macro can hide or unhide and protect or unprotect a worksheet. Use the following: There should be a space after ActiveSheet.Protect (I used a _ instead so it didn't move the parameters to the next line). The password you use is case sensitive.

Columns("B:B").Select
Selection.EntireRow.Hidden = True

ActiveSheet.Protect Password:="password",DrawingObjects:=True, Contents:=True, Scenarios:=True