+ 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
    20

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

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

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    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
    20

    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. 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