+ Reply to Thread
Results 1 to 4 of 4

Prevent user from modifying object while allowing interaction

  1. #1
    Registered User
    Join Date
    05-02-2018
    Location
    Long Island, NY
    MS-Off Ver
    2007
    Posts
    3

    Prevent user from modifying object while allowing interaction

    I have an object that I want to prevent the user from modifying. It's a link to another spreadsheet. I created it like this. On the Insert toolbar,
    Insert-Object-Create from File
    Navigate to file and select it
    Check off Link to file and Display as icon
    Click OK

    I want the user be able to click on the icon and open the file, but I don't want the to be able to resize or move the icon.

    If I protect the sheet, the icon can't be moved or resized, but it's also not clickable. Is there a way to lock the object while still allowing the user to click on it?

    I've attached a screen shot of the page.
    Attached Images Attached Images

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Prevent user from modifying object while allowing interaction

    Why not insert a shape and add a link to it?

    When you protect the sheet the user won't be able to edit/move the sheet but they'll still be able to click it.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    05-02-2018
    Location
    Long Island, NY
    MS-Off Ver
    2007
    Posts
    3

    Re: Prevent user from modifying object while allowing interaction

    I tried that. Our IT department has some kind of policy in effect that blocks hyperlinks when we click on them, whether they're local, on the network, or on the web.

  4. #4
    Registered User
    Join Date
    05-02-2018
    Location
    Long Island, NY
    MS-Off Ver
    2007
    Posts
    3

    Re: Prevent user from modifying object while allowing interaction

    I got it. It was easy enough.

    I inserted a shape and assigned it a macro with a Workbooks.Open call

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 20
    Last Post: 04-01-2020, 11:04 PM
  2. [SOLVED] Prevent user from modifying first row
    By amphinomos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2015, 12:32 PM
  3. Excel 2007 : User interaction
    By Ghost123 in forum Excel General
    Replies: 2
    Last Post: 11-25-2011, 04:18 PM
  4. Prevent user from modifying
    By VBisgreat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2011, 08:08 PM
  5. User interaction
    By ianh in forum Excel General
    Replies: 2
    Last Post: 11-26-2010, 09:58 AM
  6. Using MsgBox without user interaction
    By NJ_Dev in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2009, 05:36 PM
  7. User Form Interaction
    By webbug08 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2009, 10:03 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1