How to unprotect the attached excel..

[suryatry26]

How to unprotect the attached excel? it's possible with macros or any other option? please help me..

And I like to know how they made this protection? because here that un-protect button also not getting highlight.

[nilem]

try to remove (undo) general access to a book

[mohamedJamsheer]

http://www.theofficeexperts.com/VBASamples/Excel02.htm

[:) Sixthsense :)]

Press Alt+T+P+P which will remove/apply the protection.

Regarding the VBA Locked view - Press Alt+T+B and Unshare the workbook and press Ok.

Now it will give access to the vba project

[sweep]

Hi,

The sheet is shared. Unshare it and then you can unprotect the sheet / book and view the VBA.

[suryatry26]

hi after Unshared the Sheet macros is working. Thanks a lot.

[mohamedJamsheer]

Goto share workbook then unselelct icon...
then it will work no need vba code.

Thanks

[mohamedJamsheer]

please find sheet

thanks

[Blokeman]

@mohamedJamsheer

Forum Rules:
11. Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords.

[mohamedJamsheer]

Thanks fyi