Re: $$Excel-Macros$$ Protect : Charts, Shapes & Data
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:
>
>> 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 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
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
Re: $$Excel-Macros$$ Protect : Charts, Shapes & Data
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 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
> 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 >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
Re: $$Excel-Macros$$ Protect : Charts, Shapes & Data
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 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
> 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 >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
Re: $$Excel-Macros$$ Protect : Charts, Shapes & Data
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
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 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
>
> >> 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
Re: $$Excel-Macros$$ Protect : Charts, Shapes & Data
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
> 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 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
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com
>
>
> 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 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
<>
Re: $$Excel-Macros$$ Protect : Charts, Shapes & Data
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 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
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com
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 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
<>
$$Excel-Macros$$ Protect : Charts, Shapes & Data
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 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
Protection.xls
Description: MS-Excel spreadsheet
