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 properties, and the CHECK the lock
3. Select the data range of the chart. Right-click, and in the
properties, UNCHECK the lock
4. Now protect the sheet
On Jun 24, 11:24 am, Chandra Shekar <chandrashekarb....@gmail.com>
wrote:
> Any Ideas please. Thanks!
>
> On Wed, Jun 22, 2011 at 11:12 AM, Chandra Shekar <
>
>
>
>
>
>
>
> chandrashekarb....@gmail.com> wrote:
> > 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>wrote:
>
> >> 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 complete access to graph and data.
>
> >>> Thanks,
>
> >>> Chandra Shekar
>
> >>> --
>
> >>> ----------------------------------------------------------------------------------
> >>> Some important links for excel users:
> >>> 1. Follow us on TWITTER for tips tricks and links :
> >>>http://twitter.com/exceldailytip
> >>> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> >>> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >>> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> >>> To post to this group, send email to excel-macros@googlegroups.com
>
> >>> <><><><><><><><><><><><><><><><><><><><><><>
> >>> Like our page on facebook , Just follow below link
> >>>http://www.facebook.com/discussexcel
>
> >> --
> >> *Regards*
> >> * *
> >> *Ashish Koul*
> >> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> >>http://akoul.posterous.com/
> >> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> >> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
> >> P Before printing, think about the environment.
>
> >> --
>
> >> ----------------------------------------------------------------------------------
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >>http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> >> To post to this group, send email to excel-macros@googlegroups.com
>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >>http://www.facebook.com/discussexcel
>
>
>
> image.png
> 44KViewDownload
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
