+ Reply to Thread
Results 1 to 5 of 5

When Using Excel in One Drive Can I Hide Some Worksheets From Particular Users?

  1. #1
    Registered User
    Join Date
    08-24-2019
    Location
    Munster, Indiana, USA
    MS-Off Ver
    Excel 365
    Posts
    14

    When Using Excel in One Drive Can I Hide Some Worksheets From Particular Users?

    I have Office 365. I would like to save an Excel file to One Drive and share it with two associates.
    I will call them User 1 and User 2. The spreadsheet contains financial data and I want to limit the access
    each user has. More specifically, is it possible to specify that User 1 can only access worksheet "User1Stuff"
    and User 2 can only access worksheet "User2Stuff"?

    Here's another question. Can I prevent One Drive users from editing in the browser and force them
    to download Excel to the desktop? If so, I could use VBA macros, which are not possible when editing in the browser.

    Thank you!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,095

    Re: When Using Excel in One Drive Can I Hide Some Worksheets From Particular Users?

    Regarding the second question, no - you have to instruct them to do that.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    08-24-2019
    Location
    Munster, Indiana, USA
    MS-Off Ver
    Excel 365
    Posts
    14

    Re: When Using Excel in One Drive Can I Hide Some Worksheets From Particular Users?

    Thank you for the information.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,095

    Re: When Using Excel in One Drive Can I Hide Some Worksheets From Particular Users?

    Regarding the first: why not create separate workbooks and share them with the appropriate user?

  5. #5
    Registered User
    Join Date
    08-24-2019
    Location
    Munster, Indiana, USA
    MS-Off Ver
    Excel 365
    Posts
    14

    Re: When Using Excel in One Drive Can I Hide Some Worksheets From Particular Users?

    I'm sorry for the delay in replying. The workbooks have formulas that reference cells in the other workbooks, so I would need to have them all online for them to work properly.
    I want to restrict a given user from seeing/editing certain workbooks.
    Thanks for your help.

+ 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. Change my vba code to save excel file directly to any users desktop not via c drive
    By galbatrox9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2016, 01:22 AM
  2. Hide some worksheets of a protected sheet for multiple users
    By bolulusam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2016, 04:07 AM
  3. Cant hide worksheets after macros to force users to enable macros
    By Mboemoyo85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2015, 02:52 AM
  4. Replies: 4
    Last Post: 10-21-2012, 06:00 PM
  5. Replies: 3
    Last Post: 02-27-2006, 01:15 PM
  6. [SOLVED] Protection in Excel - how do i hide some info. from some users?
    By michael in forum Excel General
    Replies: 13
    Last Post: 12-21-2005, 11:35 AM
  7. [SOLVED] is it possible to Hide certain worksheets from certain users?
    By Admin in forum Excel General
    Replies: 2
    Last Post: 05-04-2005, 05:06 PM

Tags for this Thread

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