How to restrict access to worksheets per user

T

tahas

New member

Joined

Sep 25, 2012

Messages

4

Reaction score

0

Points

0

Location

Richmond Hill, ON Canada

Excel Version(s)

2010, 365

• Jun 25, 2020

• #1

Hello All,
Can somebody look at my code and advise what is wrong with my code?

Regards,
Taha

 

Attachments

• 
  Error.jpg

  89.7 KB · Views: 13

alansidman

Member

Joined

Oct 1, 2018

Messages

402

Reaction score

6

Points

18

Location

Steamboat Springs

Excel Version(s)

O365

• Jun 25, 2020

• #2

crossposted: https://www.excelforum.com/excel-pr...ccess-to-worksheets-per-user.html#post5354979

and

https://www.ozgrid.com/forum/index....ct-access-to-worksheets-per-user/#post1236956

 

Last edited: Jun 25, 2020

alansidman

Member

Joined

Oct 1, 2018

Messages

402

Reaction score

6

Points

18

Location

Steamboat Springs

Excel Version(s)

O365

• Jun 25, 2020

• #3

and again here: https://www.mrexcel.com/board/threads/how-to-restrict-access-to-worksheets-per-user.948330/page-3

 

N

NormS

New member

Joined

Jul 30, 2017

Messages

122

Reaction score

0

Points

0

Excel Version(s)

Excel 2016 ProPlus

• Jun 26, 2020

• #4

Select Case User
Case “Taha”
Msgbox “In the future please post your code as text, hard to correct your picture.”