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