+ Reply to Thread
Results 1 to 2 of 2

Hide Some Sheets based on the user

  1. 01-29-2019, 10:26 PM #1
    subodhsapkota
    subodhsapkota is offline
    Registered User
    Join Date
    12-19-2018
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    16

    Talking Hide Some Sheets based on the user

    I want to have a workbook and the name of the user to determine the if a particular sheet is hidden and / or shown ?
    Reply With QuoteRegister To Reply
  2. 01-29-2019, 10:53 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,855

    Re: Hide Some Sheets based on the user

    I would use the Environ("UserName") in conjunction with Workbook_Open event and create a if then scenario or a Select Case if you have many users. This is a VBA procedure.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to hide/unhide user defined specific sheets
    By LeanAccountant in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2018, 11:02 AM
  2. [SOLVED] Click a button then user is asked what qty to filter or hide rows based on user input
    By JET2011 in forum Excel General
    Replies: 15
    Last Post: 07-11-2017, 10:55 AM
  3. Hide sheets depending on user membership in security groups
    By Excel_Beginner_1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2013, 03:10 PM
  4. Show/hide sheets on file open based on user password
    By allar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2011, 12:41 PM
  5. Excel 2007 : Shared worksheet w/password to hide sheets and visible only to right user
    By Amarilis Abreu in forum Excel General
    Replies: 0
    Last Post: 08-29-2011, 11:54 AM
  6. Hide/unhide sheets based on user names and passwords
    By rama1209 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2011, 09:11 PM
  7. Hide sheets based on user using VB in Excel 2007
    By mrgillus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2009, 08:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1