Search results for query: *

Hello. Thank you for taking the time to read this. I very much appreciate it. I have a some code that scans a spread sheet that contains a lot of empty rows and copies only the rows with data to a blank sheet in the workbook. This condenses the information making it more condusive for printing...

Thank you for taking the time to help. I would like to password protect the sheets in an application that I have made but, this causes the macro code to fail at: ActiveSheet.Unprotect Is there a way to put the password in the code so that the code can continue to be executed...

Hi, The verticle scroll bar is currently scrolling to the bottom of the worksheet(65,000+). There is nothing beyond row 2500 and I have the scroll area set to stop at that point. I would like to reset the verticle scroll bar so that it is at the bottom of it's scroll at row 2500. Is there a...

Hello, Thank you for your response, I really appreciate it. I am planning a separate sheet as a help screen for the Excel App. I am making but, it is important that I return the user to the same sheet they were on last when they leave it. Any way to do this with code? I will be greatfull for...

Hello! Thanks for your response, if possible. I really need to prevent users of my Excel Application from switching between Sheets using Ctrl+Page Up & Ctrl+Page Down. I really prey someone can help! Thanks. Sincerely, Acquaman

Hello, Thanks for helping me out. I really appreciate it. I am sorting a list of formulas that all have a zero value until some text is typed into the source cells. After an A to Z sort, if the list is only partially full fo text values, the zeros are all listed first and the text values are at...

Hi, and thanks for taking time to read this. I would greatly appreaciate any help you could provide. I replaced the standard Excel Menu Bar with a new one I created. I gave the menu Bar new Menus and I gave the Menus MenuItems. But when I try to write the code to add SubMenuItems to the...

Hello, and thank you very much for takeing time to help me with this problem. What I want to have in my application is a Command Button with more than one function. Specifically, I want to VOID a document and then be able to UN-VOID it with a second click of the same Command Button. Can...

Hello! I just found out about this web site. I am so impressed. People helping people. It does't get any better than that! Here's my problem...I recorded a macro in Excell (2000) that creates a Hyperlink to another file and copies information from that file back to the original file. The macro...