• Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us

PK: An Excel Expert

Excel, VBA and Power BI tutorials

User Level Security
Power Pivot VBA

User level security in Excel Workbook for different worksheets

05 Apr 2020
19079Comments Off on User level security in Excel Workbook for different worksheets

In this article, we have created User level security in Excel workbook. If you have multiple worksheets in your excel file and you want to protect/hide the data according to the user then this is very useful trick. We have used VBA code to develop this.

In this template there will be two type of roles-

  1. Admin: can add/delete/modified the user information and worksheet access level.
  2. User: User will be able to view/edit the information in the file, according to given access.
User Management Worksheet
User Management Worksheet

As soon as excel file will be opened it will ask to user id and password. For admin we have put the user id as “PK” and password as “xyz”. You can change is according to your requirement.

Login form
Login form

Watch the step by step video tutorial:

Click here to download this template.

Tagged Excel Templates, Login form, User Form, User Form Validation, VBA
PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com

Related Articles

Time Picker
Templates VBA

Time Picker and Date Time Picker Control in VBA

June 28, 2020June 28, 2020 PK
In this article, we have created Time Picker and Date Time Picker control in VBA. We have used User form,
Universal Searchable dropdown list
VBA

Universal Searchable Drop-down List in Excel

May 31, 2020May 31, 2020 PK
In this article, we have created a universal searchable drop-down list in Excel. It is useful when you have multiple
Relationship in Power Pivot
Power Pivot

Create Relationship in Power Pivot

January 3, 2020January 3, 2020 PK
In this article, we have explained, how to create relationship in Power Pivot data model. We have taken 2 dimension

Post navigation

3D Gauge Chart in Excel
Fully Automated Excel dashboard with multiple source files

Top Categories

  • Charts and Visualization (126)
  • Dashboard (8)
  • Excel Tips and Tricks (53)
  • Power BI (19)
  • Power Pivot (14)
  • Power Point Visualization (5)
  • Predictive Analytics (3)
  • Templates (49)
  • VBA (75)

Read More about..

  • Advanced Excel
  • VBA Course
  • Dashboard
  • Chart and Visualization
  • VBA Tips
  • Excel Tips and Trics
  • Our Excel Products
  • About US
  • Contact Us

 

Subscribe to our Newsletter



Download Free Dashboards

  • Project Management Dashboard
  • Zonal Dashboard
  • Sales Dashboard
  • Outbound Dashboard
  • A Quick Dashboard
  • C-SAT Dashboard
  • Performance Dashboard
  • Process Dashboard
  • Incentive Dashboard

Recent Posts

  • How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI
  • Power BI dashboard with 3D Glass Chart
  • Use of Symbols and Emojis in Excel Drop-down List and Excel Charts
  • Five awesome formulas in Excel
  • Quick 3D Container chart in Excel
  • TEXTSPLIT function with three use cases in Excel
  • LAMBDA Function in Excel with Example
  • Data Transformation to create Comma Separated List automatically
  • Inventory Management Template for Multiple Locations
  • Paste Special in Microsoft Excel
Copyright © 2018 PK-AnExcelExpert.com - Privacy Policy