Search results for query: *

(I posted this elsewhere accidentally - apologies). I am trying to set up a customised ribbon in Microsoft Project 2010. Most of of it works fine but I am unable to get my dropdown button to function. Specifically, I cannot get the index of the selected item (or the item number for that matter)...

I am trying to set up a customised ribbon in Microsoft Project 2010. Most of of it works fine but I am unable to get my dropdown button to function. Specifically, I cannot get the index of the selected item (or the item number for that matter) to be returned. I get an 'Automation Error' with...

Thanks for your reply. I get similarly quick times when I run your code. I added some timescalevalue assignments which are computationally heavy and of course the times inflated significantly. But things remained linear. Doubling the number of tasks 1 day tasks only doubled the time as it...

I have discovered painfully that references to task properties in the form of Activeproject.tasks(ID).name and even TS(ID).name after the required 'Dim TS as tasks Set TS = ActiveProject.tasks' are hugely expensive statements to use. I have also learnt (see previous post) that the...

Hi, I am desperate for some help. I have VBA code that processes 80 high-level phases or WBS elements, each consisting of 40 rows, within the Microsoft Project task list. It takes about 75 seconds to process EACH of these phases when they are assembled in one file, which is incredibly slow...

The reason for my wanting to do this is that this is a turnkey application. The screen looks good, with no gridlines, row and column headers and no space taken for the formula bar. I also don't want any scrolling to be done. All of this can be changed by users who can then pass the...

Hi In Excel, I want to be able to hide the 'tools - options' area or prevent users from reaching there so that they cannot reveal row and column headers etc. I tried protecting the workbook but this does not work. Any help would be appreciated. Thanks

Hi, I have not had this need before but I have a display which exceeds the height of the viewable area (so that things are readable with my selected zoom size). I want the user to be able to scroll down to the bottom of the area but no further. Freeze panes does not seem to be able to do...

No, I am trying to prevent that with the Application.EnableEvents = False switch.

The Worksheet_Change routine in the Worksheet code does pick up changes caused by a validation selection list cell. I have this: Private Sub Worksheet_Change(ByVal Target As Range) Call Module1.WChange(Target) End Sub where WChange does the work reacting to the validation dropdown change...

lol...I saw Excel.Range used like this in a Worksheet_Change routine on some Excel site somewhere and in my desperation I used it. Ok. I will try all this again...but do I need the Auto-open routine? Thanks

Yes SV, this is how I created the Worksheet_Change routine in the Sheet code. However, as I said, it appears that I need another one with no code within its body in Module1 in order to avoid error messages. I don't know why.

Oh...I meant when I change a cell, the code runs. However, unless I make the parameter 'Target' Optional, I get the 'Argument not Optional' message. However, when I do this, 'Target' is not recognised and I get a 'Object Variable or With block variable not set'. I am doing something wrong...

I have read some of the responses to similar questions regarding Worksheet_Change routines that allow macros to be activated upon change to a cell. However, when I run this, (say the following), I get a 'argument not optional' message. Can anyone help? With thanks Private Sub...

Thank you very much. I will give this a try.

Hi there, Can anyone tell me how to cause a Microsoft Access report to be printed at the press of a button in Excel? Would love to know. With thanks

Hi Thanks for your reply. No, I did everything you did, including the reset and it was still problematic. However, since posting my problem, I did manage to get around it. Perhaps I was in error but this is what I was doing originally for a multiple set of decision variables: SolverAdd...

I am using Excel Solver under control of VBA. When I have a constraint with an upper and lower bound, one of these is lost. For example if A1 contains a decision variable and I have A1<=1 A1>=0 the second one simply disappears when using VBA. I would really appreciate advice on how to get...

Thanks again Geoff and Combo. I did not quite follow your instructions, particularly where to right and left click for the dropdowns (Combo) and 'dynamically write code" (Geoff) but when I corrected the definitions, it worked fine. Would love to understand that stuff eventually. Thanks guys...

Thanks Geoff and Combo for the responses. Geoff: However, I am able to generate a Click event on this button, so why not a mousedown and mouseup. What are class modules and should I get into them to solve this? Combo: Don't really understand the response. Can you elaborate a little...