Locking a sheet !

[Amit]

hello group,

I have written a VBA code and now works fine BUT I'm having a problem
as following:

Thru an installation procedure I put the "MyApp.xls" file under
/program files/MyApp. Also I have two extra file as configuration file
(INI) and log file under different directory such as /Document and
Settings/MyUsername/Application Data/MyAppFiles then during
installation I modify a registry key "AltStartup" under
HKEY_CURRENT_USER/Software/Microsoft/Office/11.0/Excel/Options. This
way everytime user runs the Excel he/she would have the menu of my
application in his/her environment accessible.


Now the problem is that:

My application bothers other Excel operations. For example after the
installation is done, if I try to read other Excel files it overwrites
the new opened sheet. I could open other Excel file, but it does not
show the data.


Ok I found it is wrong to use the Regsitry as it is mentioned but how
can I solve the problem of openning the other Excel sheets or files?
since they are covered but the one my application is using. As soon as
I close my application they show up.

your help will be appreciated.

 

[Perry]

I'm afraid we all need some more info on what yr MyApp.xls file is doing.
We don't know how yr "application" affects other workbooks ...
Can't analyse!
Pls supply some more info on the functionality.
Take one example, and pass this to the newsgroup.
Once solved, you might be able to solve all the other issues

Couple of "Any reason why" questions:
Any reason why y're using an XLS file as opposed to an XLA addin?
Any reason why y're using an INI file, where as app settings can be hosted
in Excel sheets (xlVeryHidden sheets)

Krgrds,
Perry