Hi! I have just joined and have searched for an answer to a question but to no avail. the question is in excel 2003 how do I lock an autoshape so that a user cannot select it or move it on the page. thank you in advance for any answers
Hi! I have just joined and have searched for an answer to a question but to no avail. the question is in excel 2003 how do I lock an autoshape so that a user cannot select it or move it on the page. thank you in advance for any answers
Last edited by cronic; 02-26-2008 at 08:20 AM. Reason: no title
Hi, Try Tools, Protection,Protect sheet
Regard Mick
Hello MickG
thanks for your answer unfortunately this does not work the shape can still be sellected and moved even with the sheet protected
Cronic, if you want to use the forum please read the Rules 7 use an appropriate title for your question. This helps other users.
Edit your initial post asap, thanks.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
sorry about that I stand corrected, hope it is OK now
cronic
Hi, Have you made sure the correct boxes are unchecked in the "Protect Sheet" dialog Box
It worked when I tried it !!!
Regards Mick
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks