Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Non-selectable object

  1. #1
    Board Regular wwbwb's Avatar
    Join Date
    Oct 2003
    Location
    Colorado Springs, Colorado
    Posts
    500
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Non-selectable object

    Is it possible, and if so, how can I make an object, specificly a chart on a sheet, not selectable. I have a macro that selects the chart on the page, deletes it, then makes a new chart with the new data. What I need is to have the chart not selectable by the user. Any ideas?

  2. #2
    Board Regular wwbwb's Avatar
    Join Date
    Oct 2003
    Location
    Colorado Springs, Colorado
    Posts
    500
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Non-selectable object


  3. #3
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Non-selectable object

    Right click on the chart, choose Format Chart Area > Properties tab, and select (put a check mark next to) Locked. Click OK.
    From the worksheet menu, click on Tools > Protection > Protect sheet, set your protection options and password (if any), and click OK.

  4. #4
    Board Regular wwbwb's Avatar
    Join Date
    Oct 2003
    Location
    Colorado Springs, Colorado
    Posts
    500
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Non-selectable object

    thanks.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •