Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Jun 2003
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Removing a command from a Menu (Excel 2000)

    Hi All
    I have my users enter data in a Shared Workbook. Is there a way that I can prevent the users from turning off the Sharing. I thought it could be done by removing the command from the menu? Any help would be appreciated and thanks!
    --cat

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Removing a command from a Menu (Excel 2000)

    Customizations to toolbars and menus are user-level settings, not workbook-level settings. You would have to write code that disables the Share Workbook... menu option when the workbook is activated, and enables it when the workbook is deactivated. But users with a bit of knowledge of VBA could easily circumvent this.

    Do you really need the workbook to be shared? I have only heard negative things about it - it is a source of wrokbook corruption.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing a command from a Menu (Excel 2000)

    <<...wrokbook corruption...>>
    Gets in everywhere, dunnit! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Removing a command from a Menu (Excel 2000)

    Who needs a speling chekker? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Removing a command from a Menu (Excel 2000)

    Eye no eye knead won.

    Steve

  6. #6
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Paragould, Arkansas, USA
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing a command from a Menu (Excel 2000)

    Cindy,
    Hans is right - I speak from experience. Sharing does lead to wrokbook problems. The sharing option keeps a log of changes and bloats the file, slowing things down, especially when loading it across a network. We eventually removed Sharing from many Excel files in my organization.

    Can you arrange for the users to use the file one at a time? Excel does pop up a little question dialog when the file is already open, with one option to notify the "new" user when the current user is done.

    Errol

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing a command from a Menu (Excel 2000)

    As much as I'm against sharing (!!!!!!!!!), there is an option to protect and share a workbook: Tools, Protection, Protect and share workbook. Dunno what features get blocked exactly though.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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