Search results

So we have an app called team room which is based On MOSS. I have a document library with 3 colums called project phase, activity and document type. These can be used to filter each collum. However I would prefer to have the filter controls detached from the web part. So I was going to...

Hi quick question is there functionality for naming ranges in this plugin? In normal excel I can select cells and name the range, then if extra rows are added the range expands with the rows. Cheers Dusty

=(SUM(COUNTIF(test1;{"i","ii","iii"})*{1,0,0}))/(ROWS(test1)*(COLUMNS(test1))) This the formula I am using at the moment. It calculates a percentage of cells labeled i in the range test1. Is there a way of modifying this so that it only counts if the cell is labbelled i and another cell is...

So I wish to save the contents of a VB form i.e. text box entries and combo box selections when the form has been used. Then on reload of the word document I would like this saved data to be retrieved so that the entries can be edited. I have code for doing this. I use this code to...

I have a table in excel which people can add too. When they add to the table they inesrt new rows in the relevant section. It would be nice to have code in place that when a new row is inserted specific cells are merged in that row rather than the user having to merge them themselves. Is...

I have a Column which is a long list of tools. The column is seperated into groups by headings. e.g. cell C1 is the heading "Concept" which is bold outlined and has a grey background. Beneath this in cells C2 to Cx is a list of tools relevant to the concept phase. Cell Cx+1 has another...

I have a range of cells 6 columns 9 rows which are either coloured red or green depending on the status of a task green completed red uncomplete. I want to be able to use a function/formula/macro to calculate the percentage of cells which are green. Cheers Dusty

Here is the code I am using to enter text from a text box in a userform into a formfield in a word document. Set product = ActiveDocument.FormFields("ProductName").Range product.Text = userform.productname This is great apart from the fact that it deletes the form field when entering the...

So I am trying to use code to create a table in word. So far I have managed to insert a table of variable rows and columns depending on values of x,y. This table is placed into a specified bookmark and then the bookmark is replaced after the table so that another table if required can be...

I have a form that prompts the user to tick check boxes depending on the ticks different text boxes become visble allowing the user to input values. In essence the text boxes are arranged into 6 colums and a maximum of 25 rows. Depending on the ticks rows of text boxes are hidden. I want to...

I have a userform within word. With some option buttons i want the outcome of these option buttons to affect some checkboxes embeded in the word document itself. Where do I position the code if I place the code within the useform it does not recognise the existance of the check boxes in the...

I want to be able to open one word document which has a userform set to show on open. This userform enables the user to browse for the filename of a document. A command button confirms their choice and runs the next part of the code. (I can write the code up to here) I am having problems...

At the moment I have a userform which loads on open. Private Sub Document_Open() UserForm1.Show End Sub the document is read only so when saved a copy will be made under a new filename. I want to insert an if statement to the above to check if the file is the original or a copy so that a...

I have a frozen panes such that column A is stationary and row 1. Is it possible to also freeze say column z?

So basically I have a word document set up which on load display several message boxes one after the other depending on the answer YES or NO a bookmark is found within the document and deleted. The purpose being the document is trimmed down and tailored for teh specific requirements...

Here is the code Sub Show_packaging() 'To hide columns without 2 in specific row Dim col As Range With ThisWorkbook.Sheets("Engineering") For Each col In .Range("E3:CW3").Columns col.EntireColumn.Hidden = _ Application.Sum(col) < 2 or > 2 Next End With End Sub however I get a compile...

I need to know how to compare a collumn with a cell and hide the collum the cell is in if any of the cells from the collumn do not match the cell for example IF collumn A( from A3 till end) does not = B2 hide collumn B also can this be continuosly running so that if the collum changed...

I have a table set up which lists project names their relevant buisness stream and then personal working on which projects this could be multiple. each person is a collum and can be working on multiple projects across multiple buisness streams. I have a filter set up on the buisness stream...