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 > wrote: > >

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 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 wel

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

2011-06-27 Thread Chandra Shekar
Thanks! On Fri, Jun 24, 2011 at 9:38 PM, GoldenLance 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 > 2. After dese

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 properti

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 wrote: > Try this > ri

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