+ 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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,185

    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,185

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