Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Password prompt on file open - 1 machine only
Hi to All,
Recent observation on one machine: The initial Excel file in question: A small application for costing out menus for school lunches (Food Service). This application includes 7 worksheets, opens & closes other workbooks where data is stored, & has a number of VBA routines to insulate the user. With other machines, including one with a P3, 512MB RAM, Win98, Excel2000, the application opens clean. The application was developed in a P4, 512MB RAM, Win XP, Excel 2002 environment. What I saw: When opening the primary, or control, file, the user was presented with a VBA Project password dialog box. On providing the password, I noticed that the project was set to allow compiling (As will happen when moving between Excel versions). Suspecting the user's machine setup vs. the application, I loaded a different application I developed previously and that has been tested and proven on more than a hundred machines with various setups. It too prompted for the VBA password and was set to allow compiling. After I did compile this one application, neither application opens with the password dialog, and both function properly on the user's machine. The User's machine: P3, 256MB RAM, Win98, Excel2000 - Other than background, no other applications open The User: I recall that about a year ago, the user took a class in visual basic and the user is generally curious. I can imagine that possibly, something the user tried with VB affected his VBA setup. Question 1: Is this the result of the application using the Excel 9.0 Object Library, or maybe the Office 9.0 Object Library instead of the Excel 10.0 Object Library and Office 10.0 Object Library in use when compiling? Question 2: Why would it show up on one machine, but not another nearly identical? Question 3: What happened & why was it resolved so simply? Thanks in advance for any help here. Best Regards, Walt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Prompt to Open File as Read-Only (Excel 2007) | Excel Discussion (Misc queries) | |||
Excel 2007 prompt to open file as read only | Excel Discussion (Misc queries) | |||
Prompt to Open or Save the downloaded file | Excel Discussion (Misc queries) | |||
Bypass prompt to open XML file as XML list? | Excel Discussion (Misc queries) | |||
How to stop file open macro prompt after deleting all macros? | Excel Worksheet Functions |