Search results for query: *

Hello I have a spreadsheet worksheet that needs to be protected but that allows the user to use the find function. With the WS protect and they use the find option they get the message "Microsoft Excel cannot fing the data you're searching for. Check your search options, location and...

Hi I have a form that allows the use to click on a button to input the date and time. This then needs to be added to a worksheet and need to display the date and the time within the same cell. Using the code ActiveSheet.Range("A1").Value = DateValue(txtDate.Text) this works with the...

Hi Does anyone know why when I save my excel file it goes through the process of saving twice? Any help? Thanks Regards David

Hi I have created an Excel Workbook that I populate by a form created in vba. Within this form have combo boxes that are populated when the form is displayed. I have two buttons one is to add an entry and the other is to edit entry. The edit entry button picks the data from the specfic row...

Hi Can anyone help! I have put some hyperlinked email addresses into a word document and when I click on the link the hyperlink changes colour. Is there any way that I can stop this from happening and leave it still highlighed in blue.? Thanks David Regards David

I have a user that has some how changed the views on all her folders so that the Subject field is missing. when new folders are created the subject is also missing. She does not know how she has changed it. I can put the field back in manually but does anyone know hgow to do it for all the...

Hi All Has anyone any idea why if I insert the code Page {Page}of {NumPages} (eg Page 1 of 13), in the header or footer when it displays on screen it it reads OK, but when I print it out it prints Page 1 of 1? The interesting thing is that if I copy the code to the main part of the document...

Dear All I have the countif function underneath deadline met which is =countif(f6:f400, "Yes"). I have another forumla that puts either a "Yes" or "No" in col F. When a "Yes" is put in col f I want the formula to count how many there are. The problem is that the formula does not count when a...

Dear all Is it possible to automaically resize a form when it is opened? The form will contain different amounts of data each time that it is run. Thanks David [2thumbsup]

Hello I have created a userform in XP Excel that runs an Advanced filter. What I want to do is then pull the data that is extracted from the filter into another userform. The problem that I have encountered is that the filter does not run if I call another userform, the same problem also...