combo,
Thank you. That did the trick. I was really struggling with finding a property that I could set or a method that would move the cursor up a line. I don't understand why curline=0 stopped working. But then I can't understand why filesearch was taken out.
Thanks again.
KJV1611,
I think I have not explained the problem clearly.
If I set curline=1 then the top line in the textbox is the second line of text. To see the first line, the user must click on the up arrow of the vertical scrollbar.
Originally, I had curline=0 which showed the first line of text at...
I am running XP pro 2002 sp2. I created an Excel VBA program that had a form with a textbox. The text in the textbox required a vertical scrollbar. To make sure the user saw the text from the beginning, I had a statement like
userform.textbox.curline=0
This worked fine until the "upgrade"...
Thanks Tony.
This was confusing me on these two seemingly different paths that ended at the same point. Also, I understand the other passwords etc. offer minimal protection at best. Once the workbook is opened, the rest is basically just to prevent accidents.
Very helpful, thanks.
Tony,
Thanks and your statement about encryption and password protecting being the same thing is what I was thinking. So the process of Office button - prepare - encrypt is identical to Office button - saveas - Excel document - tools - general options - password to open? Is that what we are...
Genomon,
Thanks for the reply. Your reply actually gets to the heart of my question. If you need a password to open the file and the same password is used by Excel to encrypt the file, what is the benefit in the encryption? Both methods of protecting the file (password to open and encryption)...
What happens in an Excel 2007 workbook when a user clicks through the following; Office button, prepare, encrypt document.
It seems that the password entered becomes the password to open the workbook but is that all? Is the data within the workbook encrypted and if so, how does that improve...
Gavin,
Yes, I can save the file manually. Good suggestion.
Because it seems everything is fine with the other files that I open, I decided to sort of get rid of the chart file. I manually opened the chart file and for each tab in the workbook I copied it to a new workbook. Then I had the...
I am at work now using my work computer. I will take the files home and see if I have the same issues. If not, then maybe a fresh install is the answer. I will keep you posted.
Mark
If I go the route of repairing the office install, is there something I can run from my computer (such as checkdisk or system file checker or something like that) or are you suggesting I contact our IT folks and get Office reloaded?
Mark
I did the google thing and went to the MSDN site. Here is what is out there.
Visual Basic Reference: Error Messages
Error in loading DLL (Visual Basic)
A dynamic-link library (DLL) is a library specified in the Lib clause of a Declare statement. Possible causes for this error include...
Ok. I tried saving the chartbook before closing databook. Same "document not saved" error on the save line of code. Also, the wording of the dll error is "Error loading dll". I received that error when I followed the debug button to the editor and tried to make code changes.
Mark
PHV,
I did try the first suggestion. Same problem. It won't execute the save line. I have not tried the second suggestion. I will do that and get back to you.
By the way, when I tried
workbooks(chartbook).saveas [complete path]
I get the message that the file already exists and do I want...
I have an issue with a VBA program I wrote (that is the first problem) in Excel. The program is saved in its own workbook (call it progbook). The program opens two other Excel files. One file contains data (call it databook) and the other file contains summary tables and charts (call it...
strongm,
I'm not sure that a label with extra code is necessarily better, but it is another option. Also, as Skip has said,
Textboxes are for users to enter stuff--responses.
Lables are for information.
Thanks,
Mark
Skip,
Maybe I wasn't clear or maybe it is the version of software that is causing some confusion.
I am using Excel 2002 with VBA 6.3
In this version, a textbox control has a scrollbar property. It can be set to none, vertical, horizontal, or both. The label control does not have a scrollbar...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.