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
> <samde...@gmail.com>wrote:
>
>> Hi, please find attached the sample file
>>
>> On Mon, Jun 27, 2011 at 12:17 PM, Chandra Shekar <
>> chandrashekarb....@gmail.com> wrote:
>>
>>> 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
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>
>
--
----------------------------------------------------------------------------------
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
