Search results for query: *

I agree with MightyGinger. There is little you can do to stop a determined person from breaking into your code. I once had to unlock some old code for which I had forgotten the password, and it only took a few hours to find a program which was able to unlock it for me. I'm sure there are other...

Hi, Is there any way to either control or disable the above message which appears you close a workbook? I have tried using the displayalerts and enableevents method in the Before_Close workbook event, but I can't seem to get it working as I would like. Basically, I want the user to be able...

Randy, Sorry about the extremely late reply to this post, but even though I had notification marked, I never got your reply! It was only luck that I found your reply while looking at another problem! Anyway, I did as you suggested and the problem has seemed to disappear. In the interim I have...

I think both Rob and Skip deserve a star for their efforts on this one! Matt

Yes, you can lock the macro to stop other people from viewing its contents. To do this, go into the Visual Basic editor, go into the Project Explorer right-click on VBA-Project. Go into VBAProject properties. The second Tab up the top gives you the ability to lock the Project and set a password...

Nikki, You beat me to it! That is the method I also use to disable the close button. Once again, thanks for all your help with this problem and the problem in my other thread regarding the SaveAs function in Word. Cheers Matt

Hey Nikki, If I could give you another star i would! Thanks for all your help. Now the only thing left I need to do with this thing is the Saving issue. As I mentioned in my previous post, when the user goes to save, I would like for the SaveAs dialog box to appear, with the default file name...

Nikki, I realise what is happeing now with the CreateObject code. It starts an instance of word in the Process section of Task Manager. How do i go about making the instance of Word and the current document visible to the user? The reason I want this to happen is because I am basically...

Thanks for the quick reply Nikki. That was exactly what i was looking for. Doing it with code was also pretty straightforward, so workbook protection can be turned on when opening the workbook, and off when its closed. A big star for you! Cheers Matt

Thanks for all the info Nikki. I understand the method with you are transferring the information, however I have come up with a problem along the way. I get a error saying that the OpenDocument method is not available for l_appWord. I have loaded the Word 8.0 Object Library (i'm using Word 97)...

Hi all, I have a query regarding sending data from an Access Database into a word template. Essentially, I want to be able to click a button on one of my forms in the database, and have the information contained in particular fields sent into a word template which has already been set up. I...

Hi, Does anyone know how to diable the close button on a worksheet? I know how to do this for a userform, but I am not sure whether the same method can be applied to a worksheet, and also for the workbook. Thanks Matt

Frank, I have experienced exactly the same problem as you. I am running Win2000, Office2000. On my computer, any excel files containing ActiveX Objects take about 2 secs to open per control (from the control toolbox) in the workbook. I have tried reinstalling office from scratch, but to no...

Elysium, I have the same problem that you describe. What I think is happening is that when you close down Excel, for some unknown reason any comboboxes the worksheets have their _Change events triggered. I think the error messages are coming up because the actual worksheets have been closed by...

As Skip said, the help section gives you some hints as to how to redim arrays. Note that when redimming you can only change the number of elements in the last array if you want to preserve the contents of the array. i.e. if you have your 100x100 array partially full of data and want to trim it...

Even though you have no controls on your worksheets, your problem sounds suspiciously similar to mine. Yesterday I even tried a total reinstall of excel 2000 but with no success. As you have previously mentioned, my program also works on Excel 97. It also works on an older computer on which i...

Just a question Clive. Do you have any "control toolbox" controls on worksheets (not userforms)? I am asking because I have a problem which sounds very similar to yours. My spreadsheet takes about 1 minute to load up before running any code. I narrowed the problem down to the...

A little more information regarding the above problem. I have counted the number of OLEObjects (controls) on the worksheets, and the opening time and closing time seems to be consistently 2 secs for each OLEObject i.e. If my workbook contains a total of 12 OLEObjects on its 8 worksheets, then...

I have managed to track down what is causing the massive delays. The delay disappears when I delete all cmdbuttons, labels, textboxes etc on the worksheets (note, the buttons on the userforms don't seem to affect the closing time). These buttons were created using the control toolbox. I think...

Rob, I have taken the debugging a few steps further by removing pieces of code one at a time to determine what is causing the problem. The bizarre thing is, I have removed ALL code and the extremely long closing time is still occuring. (By the way, opening the excel file takes a long time...