unprotect object on protected sheet

[ctz]

hi...
go througth my question

i make an object,function with macro on mysheet..and that sheet i have to protected but when i click on that object..it not funtion bcoz the sheet have be protected..

for an object properties i already unlocked...but still can't

...it is posibble or not we used object in protected sheet?

 

[apr pillai]

If you are using Excel 2003:

Select Tools - ->Protection - ->Protect Sheet and then put a check Mark in Edit Objects option in the Allow All Users of this Worksheet to list.

a.p.r. pillai

 

[ctz]

thanks! its really helpfull!