Re: $$Excel-Macros$$ Protect : Charts, Shapes Data

2011-07-04 Thread Chandra Shekar
Hi, Please can u expalin in steps how to do this. Thanks! On Tue, Jun 28, 2011 at 9:08 AM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Thanks its working fine. Please can u explain in steps how to do this. On Mon, Jun 27, 2011 at 6:59 PM, Sam Mathai Chacko

Re: $$Excel-Macros$$ Protect : Charts, Shapes Data

2011-06-27 Thread Chandra Shekar
Thanks! On Fri, Jun 24, 2011 at 9:38 PM, GoldenLance samde...@gmail.com wrote: I am blocked from attaching a file I guess. Not sure why. So here's how you do it. 1. Hold CTRL and right-click on the button shape as well as the chart. Go to format and properties, and then uncheck the lock

Re: $$Excel-Macros$$ Protect : Charts, Shapes Data

2011-06-27 Thread Chandra Shekar
I did as per insturction still I can able to access button. Please can u send the file. Thanks! On Fri, Jun 24, 2011 at 9:38 PM, GoldenLance samde...@gmail.com wrote: I am blocked from attaching a file I guess. Not sure why. So here's how you do it. 1. Hold CTRL and right-click on the

Re: $$Excel-Macros$$ Protect : Charts, Shapes Data

2011-06-24 Thread GoldenLance
I am blocked from attaching a file I guess. Not sure why. So here's how you do it. 1. Hold CTRL and right-click on the button shape as well as the chart. Go to format and properties, and then uncheck the lock 2. After deselecting the shapes, select only the button, again go to format and

Re: $$Excel-Macros$$ Protect : Charts, Shapes Data

2011-06-22 Thread Chandra Shekar
Hi Ashish, Thanks for the reply. Still user can edit and change text or assign a new macro the textbox, but I want user not to edit text box and assign new macro to it. Just he need to click on that to generate reports. Thanks! On Tue, Jun 21, 2011 at 9:20 PM, ashish koul koul.ash...@gmail.com

$$Excel-Macros$$ Protect : Charts, Shapes Data

2011-06-21 Thread Chandra Shekar
Hi, In sheet1 how to protect shape(Click here to Generate Report) only. I need complete access to graph and data. Thanks, Chandra Shekar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Protect : Charts, Shapes Data

2011-06-21 Thread ashish koul
Try this right click on image and chooze size and property the select don't move or size with cells [image: image.png] On Tue, Jun 21, 2011 at 5:02 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, In sheet1 how to protect shape(Click here to Generate Report) only. I need