Unprotect Shape

U

Utterly Bamboozled

New Member
Joined
Jul 7, 2010
Messages
39
Hi I've inserted a basic shape and assigned a macro to it on my worksheet. I can't work out how to unprotect this shape (hence enabling the use of the macro button) whilst keeping the rest of the worksheet protected.

Thanks in advance for your help!
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
Unprotect your sheet, and right click on on shape and select format shape, click properties and uncheck lock. (Excel 2007 and 2010)
 
Upvote 0
Sorry ayazgreat are you sure there's a properties section in the format shape menu? I've got Fill/Line Colour/Line Style/Shadow/3D Format/3D Rotation/Picture/Text Box - none of which have any protection options...
 
Upvote 0
ayazgreat said:
Yes I am sure, after the Size and before the Textbox there is a properties.
Click to expand...

Sorry ayazgreat, whilst I have been able to unprotect my object the macro still doesn't work when the sheet is protected saying, 'The cell or chart that you are trying to change is protected and therefore read only'.

Any ideas on what else I have to do to enable the macro whilst the sheet is protected?

Regards,

UB
 
Upvote 0
Ok, then unprotect your sheet and during the protection again and before giving password , mark check in "Edit Object" under the header "Allow all user of this worksheet to"
 
Upvote 0
Utterly Bamboozled said:
Sorry ayazgreat, whilst I have been able to unprotect my object the macro still doesn't work when the sheet is protected saying, 'The cell or chart that you are trying to change is protected and therefore read only'.

Any ideas on what else I have to do to enable the macro whilst the sheet is protected?

Regards,

UB
Click to expand...
It sounds like the macro is enable alright, but that your macro operations are trying to change something in a protected sheet. Is that what's happening? If so, unprotect the sheet at the start of the macro, and reprotect it at the end.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Disable shapes when Workbook is protected VBA
2
Replies
12
Views
423
mumps
mumps
B
  • Question
Event code to give message box and change color of auto-shape
Replies
4
Views
155
bh24524
B
L
  • Solved
VBA to resize shape incrementally
Replies
3
Views
197
Lil Stinker
L
A
  • Question
VBA to unlock worksheet when clicking on "refresh all" ribbon button so it can refresh a power query source
Replies
1
Views
386
PeteWright
PeteWright
R
  • Question
Macro Assigned to Shape Changes Active Sheet
Replies
1
Views
497
Jaafar Tribak
Jaafar Tribak

Forum statistics

Threads
1,214,911
Messages
6,122,198
Members
449,072
Latest member
DW Draft

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top