+ Reply to Thread
Results 1 to 2 of 2

Prevent users from unhding hidden tabs | prevent users from accessing VBA

  1. #1
    Forum Contributor
    Join Date
    08-06-2018
    Location
    Virginia
    MS-Off Ver
    2019
    Posts
    208

    Prevent users from unhding hidden tabs | prevent users from accessing VBA

    Hello Experts:

    I need some assistance with preventing users to a) un-hide hidden tabs and b) access VBA code.

    Background:
    - The attached XLSM (blank sheets for demo purposes only) includes 3 tabs: "Dashboard", "Data", and "Lookup".
    - The 1st tab "Dashboard" shall be visible to all users upon opening the file.
    - The 2nd & 3rd tabs ("Data" & "Lookup") will be hidden tabs... for demo purposes only, I did NOT hide them for now.
    - Also, I have included a generic VBA welcome message (thrown upon opening the file).

    Here's what I'd like to achieve:
    - I would like to prevent users from accessing the (later on) hidden tabs "Data" & "Lookup".
    - Naturally, any administrator needs to be able to access/view/modify anything on those 2 tabs as well as access the VBA code. Administrator will have a password (e.g., "1234").

    My Question:
    - Is it possible to add, e.g., a password (e.g., "1234") so that regulars users **without** the password A) CANNOT un-hide the hidden tabs & B) CANNOT access the VBA code/modules?
    - If so, how could such be added to the attached sample XLSM?

    Thank you in advance!
    EEH
    Attached Files Attached Files
    Last edited by skydivetom; 11-25-2020 at 12:34 PM.

  2. #2
    Forum Contributor
    Join Date
    08-06-2018
    Location
    Virginia
    MS-Off Ver
    2019
    Posts
    208

    Re: Prevent users from unhding hidden tabs | prevent users from accessing VBA

    Found the answers for both:

    https://trumpexcel.com/hide-worksheet/
    https://www.excel-easy.com/vba/examp...ect-macro.html

+ 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. [SOLVED] Prevent users from saving changes on my worksheet
    By Philipsfn in forum Excel General
    Replies: 5
    Last Post: 10-30-2019, 01:57 PM
  2. Prevent users from sharing a file
    By Jona2491 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2013, 05:32 PM
  3. Prevent users from saving
    By hr3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-20-2006, 10:36 PM
  4. How to prevent users from deleting tabs
    By moike in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2006, 10:52 AM
  5. [SOLVED] Prevent wandering users
    By cindee in forum Excel General
    Replies: 2
    Last Post: 10-05-2005, 04:05 PM
  6. prevent users from overwriting other users data
    By tino.toendra@gmail.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-17-2005, 04:06 PM
  7. how do I prevent users to go into locked cells
    By Farchid in forum Excel General
    Replies: 2
    Last Post: 02-11-2005, 05:06 PM

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