Code working in one username but not in another

rama1209

New Member
Joined
Feb 25, 2011
Messages
22
http://www.box.net/shared/t999283714

I am trying to modify code where the user name manager (password secret) will see /have access to all the sheets, but user name Niraj (password urmila) will have access only to that sheet and so on..
It works in one windows login account but stopped working when I login using a different windows login. Please help guys...To view code password is donttouch
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
have a look at the case of the users account

I've tried converting case and using that authority, for the mean time i have settled on one entry as lower case, and one as sentence case, and that's working
 

Watch MrExcel Video

Forum statistics

Threads
1,109,163
Messages
5,527,163
Members
409,750
Latest member
BorisYeltsin

This Week's Hot Topics

Top