asked on

Macro Error - Calling a macro to protect sheets

Putting the finishing touches on a project. I built a macro that will unprotect the sheets, then clear the contents of different ranges, then protect the sheet again.

the unprotect and protect are previous marcro's.

I keep gettin an error when it calls to protect the sheet again. Can't figure out why?
thanks
expert.xls

ragnarok89

Odd,

your macro works fine on my machine, XP SP# and Excel 2003.

ragnarok89

that's SP3, by the way

Brent

ASKER

The clear all marco worked?

the protect all and deprotect all work just fine.
It is the Clear all macro that I am having issues with.

thanks

ASKER CERTIFIED SOLUTION

Member_2_6169280

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Brent

ASKER

I installed the code and it only clears day1, not the other days.
so I am guessing it is not going into group mode.

I'll keep looking at it.

thanks

Member_2_6169280

oh you could add the following and update the range clear contents

Sheets("first day of pay period").Activate
Range("A4:C31").ClearContents
Sheets("2nd day of pay period").Activate
Range("A4:C31").ClearContents
Sheets("3rd day of pay period").Activate
Range("A4:C31").ClearContents
Sheets("4th day of pay period").Activate
Range("A4:C31").ClearContents
Sheets("5th day of pay period").Activate
Range("A4:C31").ClearContents

Brent

ASKER

yes, this worked perfect.

thanks for the time.