Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Cannot view code in VBE of a file with no password protection

If the workbook is shared, you'll get this message.
Inside excel (not the VBE)
Tools|Share Workbook
is where you'd check (and unshare it)

If you're using xl97 and the project was protected in a newer version (xl2k or
higher), then you'll see this message. Use xl2k (or higher) to open the file
and remove the password. Then save it without the password so that xl97 can
view the project.

Subodh wrote:

I cannot view the code of a project in the Visual Basic Editor.
It says "Project is unviewable." with title "Project Locked"
It should prompt for password if the file was password protected from
the Protection--Lock project for viewing.
However this is not the case.
Is this some sort of protecition or is it something else than a VBA
Excel File??
Is there some way I can view the code??
Thanks in advance.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Password protection in macro ( Anybody can view my password in VB Sherees Excel Discussion (Misc queries) 2 January 24th 10 10:05 PM
Cannot view code in VBE of a file with no password protection Subodh Excel Programming 0 September 22nd 09 02:43 AM
way to view excel workbook only by password protection S.REYNA Excel Worksheet Functions 1 May 28th 09 03:57 PM
password protection via code swatsp0p[_2_] Excel Programming 6 September 5th 06 09:48 PM
VBA code delete code but ask for password and unlock VBA protection WashoeJeff Excel Programming 0 January 27th 04 07:07 AM


All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"