unprotect object on protected sheet

ctz

New Member
Joined
Aug 21, 2008
Messages
26
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? :confused:
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

apr pillai

Board Regular
Joined
Aug 12, 2008
Messages
235
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
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,098,868
Messages
5,465,169
Members
406,415
Latest member
silungwewilliam

This Week's Hot Topics

Top