Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
kgb kgb is offline
external usenet poster
 
Posts: 3
Default Excel AddIns VBA Locking v Unviewable

H
I have two Excel AddIns obtained from different sources
When I try to look at the VBA code one asks for a password, whereas the other simply states that the project is unviewable
Can anybody explain
- what is the difference between these
- how is a project made unviewable (I already know how to protect a project with a password)
Thanks in advance
KGB
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 811
Default Excel AddIns VBA Locking v Unviewable

Hi KGB,

If you are running Excel 97 and the add-in was password protected in
Excel 2000 or later, Excel 97 will not be able to unprotect the project.
This is because the protection algorithm was updated in Excel 2000.
Unlikely, but also a possibility, if the add-in was created in Excel 95 you
will not be able to view the code in any later version of Excel.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"KGB" wrote in message
...
Hi
I have two Excel AddIns obtained from different sources.
When I try to look at the VBA code one asks for a password, whereas the

other simply states that the project is unviewable.
Can anybody explain
- what is the difference between these.
- how is a project made unviewable (I already know how to protect a

project with a password).
Thanks in advance.
KGB



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default Excel AddIns VBA Locking v Unviewable

Another way to get that message is to share the workbook.

Do you see [Shared] in the title bar?

KGB wrote:

Hi
I have two Excel AddIns obtained from different sources.
When I try to look at the VBA code one asks for a password, whereas the other simply states that the project is unviewable.
Can anybody explain
- what is the difference between these.
- how is a project made unviewable (I already know how to protect a project with a password).
Thanks in advance.
KGB


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel AddIns VBA Locking v Unviewable

Hi everyone,

I would like to find out if there is a way for me to view an unviewabl
project? Apparently, the author of the project
has already left the company and did not provide us any guidelines o
how to make his locked project editable. I was asked by my superiors t
make some changes in his program, but
I am currently faced with this dilemma. I would greatly appreciate an
assistance on how I could crack or make his vba project editable.

I am using excel 95.

Thanks in advance.

-marij

--
Message posted from http://www.ExcelForum.com

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel AddIns VBA Locking v Unviewable

sorry make that excel 97..

hope someone can help me here..

thanks,
marij

--
Message posted from http://www.ExcelForum.com



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Excel AddIns VBA Locking v Unviewable

Hi, recommend you to use Excel Password
http://lastbit.com/excel
Best regards, Tim

marijo wrote in message ...
sorry make that excel 97..

hope someone can help me here..

thanks,
marijo


---
Message posted from http://www.ExcelForum.com/

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
VBE Error (Project unviewable) Tia[_3_] Excel Worksheet Functions 0 July 24th 08 10:28 AM
Excel VBA Locking / Unviewable KGB Excel Programming 1 April 21st 04 05:12 PM
VBA project unviewable in office 97 Rob Excel Programming 4 January 19th 04 06:36 PM
VB project locked and unviewable Eric L. Vogel Excel Programming 4 October 8th 03 05:02 PM
Project is unviewable Marilyn Ricciardi Excel Programming 1 October 8th 03 04:30 AM


All times are GMT +1. The time now is 12:01 AM.

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

About Us

"It's about Microsoft Excel"