Search results for query: *

Hello again Whilst reading the following thread Getting rid of excess rows in Excel 2000 thread68-338110 I found a solution to my problem it might help you. Cheers Neil

Hello Sorry that I cant provide a solution to this probelm but we appear to be having the same one. Have you found a solution outside of this forum that you just haven't posted on? Cheers Neil

Thanks again for continuing to look at this. Ill try the posted code see what I get and then customise. Ill let you know the outcome and post when I complete it. Cheers Neil

Cheers guys. The example code was just that and unfortunately the number of rows and consequently the final total of optionbuttons overall will change from document to document, up to 10 different documents, up to 16 if not more rows eventually on some documents. Having the variable option...

Cheers PH There in lies the problem these optionbuttons are embedded in the document. Any other ideas Cheers Neil

Hello again Still getting the error using the Me command. I know this works on Userforms even Me.Controls but not in this instance using the embedded controls in the document. This is a little frustrating as I have used the Me method alot. Any more ideas? Many thanks in advance. Neil

Cheers guys To clarify 1. Gerry they are embedded on the word doc as Active X controls. 2. PHV I have tried the Me option, which has worked on UserFroms, but got problems with not supported or object required error. Granted I did Me.("SCheck" & j) not just Me("SCheck" & j). Hopefully the...

Hello all I have a small problem. I am working in word on a form for users to fill in , almost like a 1 to 3 kind of questionaire, where they select only one option. Unfortunately I need to identify which one has been checked in order to give me the total for the selections i.e. overall opinion...

Hello again Looks like I have another problem. Whilst I could alter the checkbox name by appending a variable to it I cant seem to do it with the optionbutton. I've tried me.controls, that didnt work, but it has in the past on userforms. Is there any way I can do that? Here's the code as it...

Cheers guys So simple, not sure whether I mean the solution or me!!! :0 Many thanks again. Neil

Hello all I am using Word Forms to set up a form for users to fill in.(I know all about Info Path and web based options but am restricted by availability and access rights.) Here goes the process: The user completes a single checkbox on each row. Once a single box( Named Scheck11, SCheck12...

Many thanks to all. Nice to know that I wasnt the only one banging my head. Unfortunately I am using 2000 so until our network goes for 2003 Im stuck and Ill have to trust the users not to goof up and leave it unprotected. Aaaaaarrrrrrrggggghhhhh!!!!!! Thanks again everyone a very useful...

Hello all Is it possible to share and protect and unshare and unprotect in VBA. I have found the activeworkbook.exclusiveaccess and the unprotectshare and protectshare properties but am having difficulty piecing it together as I have to keep messing about to access the code as the shared book...

Hello all I have a central workbook used to collect data from more than one colleague. It has been set up to allow filtering to allow separate colleagues to filter their required data set. This has been set up using a custom toolbar with CommandBar drop down. However the sheet is also...

Hello all Is it possible to change the error displayed when a protected cell in excel is edited? If its necessary to do this using code thats no problem, although I have tried to record the error in order to see if its possible to change it for a message box. Many thanks in advance Neil

Hi VBA Just reading this post to debug an autofilter issue and noticed that you said you had code for checking an autofilter has been applied or already applied could you possibly post this as I believe this is what I need for my bug. Many thanks in advance Cheers Neil

Yeah thought of that one Skip as the filter value comes from an MSOCommandBar drop down, I made it a Public variable anyway, although its not consistent in its filter behaviour, but thats another bug and has kind of put me off. Ill try and refine if Im feeling generous its taken me that long...

Thanks Skip but... The filter is applied before a new column is inserted with the formatting and depends on various other conditions (See Read and Write to User Form Thread you helped me with). Sp this may cause more problems than its worth. I thinks the head with hammer may be what Im doing...

Hello all I am trying to format ALL cells within the list, to have gird lines around the cell, including the hidden cells, so that when the filter is removed all cells have been formatted the same. As you can imagine it works fine for the unhidden cells but leaves blanks around the filtered...

Just a possibility you are still in design mode from the control toolbox Look for the set square and pencil symbol and make sure its off/risen not sunken. Hope this helps Neil