Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Jose,
Compiled executable? Are you trying to access the VBA IDE or VB6 IDE? A compiled VB6 prog. has no IDE. -- John johnf202 at hotmail dot com "jose" wrote in message ... Hi there! Got a problem and would like some help. Where I work we have many predesigned excel spreadsheets used by engineering types to store stuff for each job that they work on. A vb program is used to find and launch the same sample.xls file in its' job# folder. In order to update the sample.xls worksheet with a new combo box and the code associated with it, I used the vb program that launches the excel stuff to add said cb and code. In addition, the newer sample.xls spreadsheets VBE windows were assigned a password so that our engineers would not gp into design maode and screw things up. To get into the code at runtime I used the sendkey command to do : alt,t,e,"password",enter,enter. This has works in Windows 98. In Windows 2000, it works fine while you're in the IDE. However, if you run the compiled executable it apparently does not. I get a "Error: 50289 Can't perform operation since the project is protected" message. I searched and found some keyboard driver problem that causes the keyboard to freeze and SP2 fixes. I applied SP4 for Win 2000 and SP6 for VS/VB6. It stills does not work on Win 2000. Anyone have a handle on this problem? Got any ideas? Help, please! Jose aka Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting password on worksheet in Excel 2000 | Excel Worksheet Functions | |||
sendkey help needed | Excel Discussion (Misc queries) | |||
User not being prompted to enter Password to modify Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 Invoice Template Macro Password? | Excel Discussion (Misc queries) | |||
Linking to a Password Protected Document in Excel 2000 | Excel Discussion (Misc queries) |