Search results for query: *

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 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...

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

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...

Hello all Thanks to a previous thread I have been able to set up the following form to have its checkbox captions defined as visible elements of a filtered list. However due to what I need it to do it spreads the visible checkboxes unevenly across the form obviously because it only shows a...

Hello all I have been working on a combobox for a toolbar that seems to have an erratic performance. It works quite happily for a while and then throws up an out of range error. It uses a Public array to populate the choices with sheet names and then use those values to select a sheet based...

Hello all I have reached a desperate point which I would really appreciate help on. The code below was orginally used on an unfiltered list with the data populating it spread on separate worksheets. It worked without any problems. I have now centralised the data on one sheet for easier...

Is it possible to format indvidual gridlines on excel charts e.g. in order to set a baseline to facilitate identifying those parts that fall above or below it. Many thanks Neil

Hello all The following code works as two individual parts, one to trap the errors and one to display the "are you sure" type message. Sub checkit() Dim cont As range For Each cont In range("stuff2") On Error Resume Next iAnswer = MsgBox("A value has been deleted or removed from...

Hello all I have a colleague who wants to have a chart with the scale inverted on the Y axis i.e. instead of 1 to 7 7 to 1. Excel provides a values in reverse order function but this is not a mathematically sound representation. Is there another method either VBA or pivot tables that would...

I have a workbook that needs a value to change in a cell every literal year i.e. 365 days or on a specific date i.e. January 1st. setting the value and incrementing it is not a problem, but how do I provide a solution to the date? Is it possible to pull the system date and set it within code...

I am using some java drop down menus that when the back button is used do not function as they did on the orginal loading of the page. How do I set this up so that they can. Ideally reloading the menu completely as each page is opened/visited would be good forcing the user to rechoose from the...

Is it possible to set the opening/pop up window's properties in the window thats opening instead of setting as part of the a href that opens it? I have the opening window reference as part of some hotspot coding and setting the properties in here doesnt seem to work. <area shape="poly"...

Can anyone help I am looking to make an email template form based so that when the form is completed it will send the recipient a text based email. many thanks in advance

Can anyone help? I am trying to set up some email templates for outlook that can be used to replace a comsiderable amount of office paperwork. These documents could do with having form fields to fill in but whilst the idea of fields and controls on the form is easy to understand some elements...

Hi all I am sure I'm not being stupid or thick here but there is a method to synchronise my outlook calendar on my laptop with my calendar on the network isnt there? Surely the principle is exactly the same as synching a pda with a PC isnt it? So why is my network manager telling me there...

Hi all I work as a teacher and was wondering if an academic calendar was available for outlook to allow me to specify lesson periods lunch and breaks etc. either that or can I customise the current calendar to allow me to do this, Unfortunately whilst the lessons are an hour long the breaks etc...

I have the following script from Javascriptsource that relates to a condtional menu form created in the body. Thanks to vibris I can now call the head script so I only need to edit it once in the source file. How can I can do the same for the body calling the form into a table on the page, so I...