Excel 2003: hide rows in protected template

[DajTwo]

I am trying to let the user hide a variable number of rows in a protected spreadsheet.

I could create a macro that would unprotect and hide the rows selected however the problem is that the user cannot select rows while the sheet is protected..

Any way around that?


If I did not say it before, I really appreciate the time and expertise of the users on this forum.

 

[SkipVought]

Hi,

Selecting rows is not the problem. You can configure Protect to include selecting.

The problem is that HIDE/UNHIDE is not an option. That's where a macroe sould help.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[DajTwo]

Thanks Skip

Ill look into it..

If I did not say it before, I really appreciate the time and expertise of the users on this forum.