Aleng New Member Joined Jul 27, 2010 Messages 37 Jul 28, 2010 #1 I have a code to remove password or unprotect sheet but not the workbook. If anyone here has some idea, please help, thank alot!
I have a code to remove password or unprotect sheet but not the workbook. If anyone here has some idea, please help, thank alot!
S Simon Lloyd Well-known Member Joined Sep 10, 2006 Messages 756 Jul 28, 2010 #3 Breaking workbook security questions are frowned on, what's your purpose?, if you own the workbook you will know the password.
Breaking workbook security questions are frowned on, what's your purpose?, if you own the workbook you will know the password.
pedie Well-known Member Joined Apr 28, 2010 Messages 3,875 Jul 28, 2010 #4 May be the user might have forgotten the password.... do u have the answer????
S Simon Lloyd Well-known Member Joined Sep 10, 2006 Messages 756 Jul 28, 2010 #5 ADVERTISEMENT If the user has forgotten the password they can copy all the data ...etc to a new workbook, you do not need the workbook password for that.
ADVERTISEMENT If the user has forgotten the password they can copy all the data ...etc to a new workbook, you do not need the workbook password for that.
pedie Well-known Member Joined Apr 28, 2010 Messages 3,875 Jul 29, 2010 #6 What if the worksheet was completly protected...lol! Nothing agianst "u" but i think the user itself does not bother to check in anymore....
What if the worksheet was completly protected...lol! Nothing agianst "u" but i think the user itself does not bother to check in anymore....
pedie Well-known Member Joined Apr 28, 2010 Messages 3,875 Jul 29, 2010 #7 weskty22 said: Great.... hehehe... Let me try your code... Click to expand... Jokes apart...any idea???? I also have the code to unprotect the sheet only but was curious when this code came in...may be it can be very usefull in different ways...dependent on the users intention.... Ped
weskty22 said: Great.... hehehe... Let me try your code... Click to expand... Jokes apart...any idea???? I also have the code to unprotect the sheet only but was curious when this code came in...may be it can be very usefull in different ways...dependent on the users intention.... Ped
Peter_SSs MrExcel MVP, Moderator Joined May 28, 2005 Messages 47,475 Office Version 365 Platform Windows Jul 29, 2010 #8 Please refer to this Board Announcement and to point 20 in the Posting Rules This thread has now been locked.
Please refer to this Board Announcement and to point 20 in the Posting Rules This thread has now been locked.