I've taken a look at the task manager, and noticed excel is only occupying 50% of my processor usage, meaning that only half of the 2 cores are being used.
What can i change to force excel to utilise both cores?
I am trying to set up a time sheet for staff where it calculates hours worked in and outside of core hours. I can do a calculation to work out what they have worked in and out of core hours providing that part of their time starts of finishes in core times. The problem I am having is when some one works only outside core hours. Our core hours are 6am to 6pm. The problem is when they work from say 7pm to 1am. This is irregular work paid as overtime not shift work.
View 5 Replies View RelatedRecently the company I work for moved onto Citrix and we found unless you limit the number of processors that Excel can use you can end up with performance issues. We believe the performance issues are caused by Excel taking system resource away from the network controller on the virtual PC and causing lookups to essentially hang Excel. So I want to set the number of processors Excel can use to 3 which leaves 1 alone, when we do this for users who are having troubles this has always fixed the issue. However as Microsoft wont let currently control the number of processors used by Excel with group policy or registry the only option I have found is using an Excel add-in which I found on this website: [URL] ..........
Below is the code I am using in my add-in, which works perfectly for any new documents which are created in Excel. My problem is I can't get the add-in to apply to existing documents and I can't understand why. I have saved the add-in as an XLA file and placed it into the C:Program FilesMicrosoft OfficeOffice14XLSTART folder. If I open the existing document and then double click the add-in, then it applies I just can't get it to run automatically.
Private Sub Workbook_Open()
' Manual Mode '
Application.MultiThreadedCalculation.ThreadMode = xlThreadModeManual
' Use 3 CPU '
Application.MultiThreadedCalculation.ThreadCount = 3
End Sub
I need to calculate average response time, the problem is that it should be based only on "core hours" and that's between 7am - 6pm.
How to create function that will exclude "out ot hours" time (6pm-7am) from the calculation.
I have been working on a timesheet but the problem I have come across is calculating actual hours worked only in the core hours and any work outside the core hours is calculated in the outside hours column. A standard work day is 7.6 hours working between 8.30am and 5.00pm. However if someone was to commence work either before 6am or after 8pm this is outside of core hours. I have attached an example of my timesheet for you to see what I am talking about.
View 3 Replies View Relatedi put this code to thisworkbook to disable print function
View 13 Replies View RelatedIs there any code that will automatically enable macros on Auto_Open?
View 6 Replies View Relatedi want to dis able and enable this button using three criteria, and auto paste the comment to other sheet.
View 2 Replies View RelatedI have excel sheets that cross link with each other. I've just migrated to Office 2007. When I open my excel sheet I always get the question at the bottom of the tool bar Security Warning Data connections have been disabled. And then I have to click on option and enable content.
My question is, how do I always enable the content?
****** http-equiv="Content-Type" content="text/html; charset=utf-8">
****** name="ProgId" content="Word.Document">
****** name="Generator" content="Microsoft Word 14">
****** name="Originator" content="Microsoft Word 14">
I have opened a dodge workbook on which disabled the Feld List button in the pivot table contextual tab Options>Show>Field List.
I found the following line of code which confirms the command as being disabled by returning a FALSE message.
MsgBox Application.CommandBars.GetEnabledMso("PivotFieldListShowHide")
Now I need the code tore-enable this command.
I have a workbook which uses data connections to our sage accounts product. Everytime i open the sheet i get the "Data Connections have been disabled" security message, and need to go in and enable them. Is there any way of enabling the data connections by default? I only want to do it for this one workbook - i still want to be prompted when i open other workbooks.
View 2 Replies View RelatedI have a workbook with the following:
Code:
Private Sub Workbook_Activate()
Application.CommandBars("Ply").Enabled = False
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""RIBBON"",FALSE)"
End Sub
Code:
Private Sub Workbook_Deactivate()
Application.CommandBars("Ply").Enabled = True
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""RIBBON"",TRUE)"
End Sub
All of a sudden my right-click isn't enabling when I reopen Excel. I can run the macro
Code:
Application.CommandBars("Ply").Enabled = True
once opened, but once I close it out again, the right-click is disabled.
Is it possible to enable/disable a texbox in excel which has been assigned a macro. To make it clear I'm not talking about a textbox within a userform. I understand I should really be using command buttons but I prefer the look of textboxes.
I have the following code to change the colour of the textbox (name: txtCreateInvoice) but the final line to disable the textbox doesn't work.
Code:
Sheets(1).Shapes.Range(Array("txtCreateInvoice")).Select
With Selection.ShapeRange.Fill.ForeColour
.ObjectThemeColor = msoThemeColorText1
.Brightness = 0.5
End With
Selection.Enabled = False
I have a spreadsheet with a web data import query that is set to automatically refresh whenever I open the spreadsheet,
But whenever I open the spreadsheet, I get a dialog box "Query Refresh" that tells me my workbook contains queries to external data that refresh automatically.. etc., etc. This requires that I click "Enable automatic refresh" to get close the dialog box and start the import.
I want to get rid of the warning box, and just have it run after being started.
I have converted an Excel file from 2003 to 2007. The file now has a .xlsm extension as it contains macros. I have "enabled all macros" and "trusted access to the VBA project object model". Whilst open, I have tested the macro buttons and they work.
I then close the file and re-open it, and the macro's will not work. A message appears along the lines of "macros are anabled" or "macro is not found". I have double-checked the settings and everything appears normal.
How do I enable macro recording in Excel2003? When I select Tools - Macro, the 'Record New Macro' selection is disabled. How do I enable it?
View 2 Replies View RelatedI want the user of a file to be able to click on a particular cell and if they right click an option 'Change' will appear on the list of options and on clicking it a macro is enabled.
View 9 Replies View RelatedIs it possible to add a piece of code with the below code.
There are two Buttons in my Work Sheet. One "SAVE" the other "PRINT". If PRINT button is clicked by mistake before clicking SAVE button, a Pop up message should say "SAVE DATA FIRST". If Data is saved then based on that I should be able to Click PRINT Button.
( Or )
Enable PRINT Button only after DATA is Saved
Sub saveit()
With Sheets(2)
r = .Range("B65536").End(xlUp).Row + 1
InvN = Cells(15, 4).Text
'Clicking the "SAVE" button Without entering datas in the rest of the Fields,
'ie., in C18, C20, C22 and C24 should NOT save the Current Invoice number
'with the rest of the details in the next sheet. A pop up should say that
'"Fill all Fields" when trying to hit the Save button if a Field is blank.
If Range("c18") = "" Or Range("c20") = "" Or Range("c20") = "" Or Range("c22") = "" Or
Range("c24") = "" Then
MsgBox "Please fill all required fields", vbCritical, "Missing data"
Exit Sub
End If
On several of my worksheets, I'm asked if I want to disable/enable the macros but there are none associated with that particular worksheet- matter of fact, none of my worksheets have macros unless pivot tables count, so why am I being prompted in that way?
View 9 Replies View RelatedI have a ton of text boxes on a userform that are in an initial state of being disabled. Is there a quick way of enabling by use of a mask for these Text Boxes ?
All the text boxes I want to enable are named "TB_fieldname" and by mask I mean a snippet of code using something like "TB_*"
Example
tb_liqname, tb_casecost, tb_bottleprice etc etc..
I saved the workbook as Macro enabled workbook in 2007. Also changed the security level to 'Enable all macro'. But the Macro buttons on the developer tab still shows disabled. Also not able to open VBA window with Alt+F11 key.
View 9 Replies View RelatedI'm using the following code to automatically install the Analysis ToolPak Add-ins...
Private Sub Workbook_Open()
If Not AddIns("Analysis ToolPak").Installed Then AddIns("Analysis ToolPak").Installed = True
If Not AddIns("Analysis ToolPak - VBA").Installed Then AddIns("Analysis ToolPak - VBA").Installed = True
End Sub
... However, completion of the ATP-VBA install requires in the VBE that Tools> Reference and ATPVBAEN.XLA be enabled.
What VBA code do I need to complete this last step?
With Sheet4
ActiveSheet.Unprotect Key
.Rows("13:252").EntireRow.Hidden = False
If Me.OptionButton1.Value = True Then
.Range("MyMrate").Range(Cells(Val(Me.TextBox1), 1), Cells(Val(Me.ComboBox1), 1)).Value = .OLEObjects("TextBox" & i).Object.Text
.Range("MyMcash").Range(Cells(Val(Me.TextBox1), 1), Cells(Val(Me.ComboBox1), 1)).Value = (.OLEObjects("TextBox" & i).Object.Text * (Range("MyRSF") / 12))
ElseIf Me.OptionButton2.Value = True Then
End If
End With
For some reason, once the code runs, it calls this code,
Private Sub combobox1_Change()
Me.TextBox2.Enabled = Me.ComboBox1 ""
If Me.ComboBox1 = "" Then
Me.TextBox2.BackColor = RGB(225, 225, 225)
Else
Me.TextBox2.BackColor = RGB(255, 255, 255)
End If
End Sub
And then I get an error message that the code could not set the enable property of Textbox2.
My ENTER button in my keyboard does not work.
I think it is because I have disable it.
does anybody know hot to enableit?
kind of:
Application.OnKey "^"
but don't know which one!
I am trying to use the EnableMacros. zip script located here {url} But I am having a hard time making it work!
1. I have copied the module in EnableMacros.zip and imported it into my workbook.
2. I have placed identical code in my workbook's ThisWorkbook as is in the EnableMacros.zip's ThisWorkbook.
3. I have copied Sheet1 from EnableMacros.zip titled "Info Sheet". In MY workbook it is sheet7, but it is titled the "Info Sheet" in the EnableMacros.zip.
4. I have also copied sheet6 from EnableMacros.zip into my workbook and titled it "LoadScreen". In EnableMacros.zip the sheet is titled "Sheet1"
...
I'm trying to make a VBA project backward-compatible from Excel 2003 to Excel 2000. My problem stems from Excel 2000's inability to save a file if the VBA project protection is enabled and the password has not been entered. I am trying to code around the problem by turning off screen updating, using .SendKeys to enter the password, saving the file, and then re-enabling protection of the project. The only way that I have been able to re-enable protection in practice is to close the file and re-open it, but I haven't been able to accomplish this using VB script.
View 9 Replies View RelatedI have a spreadsheet sent in an email. When I open it there is a warning bar saying
"Protected View This file originated from an Internet location and might be unsafe. Click for more details." then a button with Enable Editing.
I click the button and can edit the spreadsheet and save my changes. But the next time I open the file I get the same warning again. What is the way to designate that this spreadsheet is safe and prevent the warning recurring whenever I open the file?
I have a couple spreadsheet Excel 2003 that I have to Email, I use a few macros with these spreadsheets. The Macros are kept in my personal workbook. When I Email these sheets does the end user see the warning enable macros or do they just see the sheet as is. I am mailing the whole workbook but macros are in my personal workbook. If they see the warning is it possible for me to Email so they will not have to contend with that?
View 3 Replies View RelatedI have Excel file that is linked to Access Database. Everytime the user opens the file, there is pop up message that warns the user we there to enable the macro or to disable it. I want to force the user to enable the macro or even better if I can make disappear this warning and automatically enable the macro. See attached for more details.
View 3 Replies View RelatedI have the following script in a command button. the command button is for the month of january. I would like to enable the button based on if a cell value is January, or unenable it based on the cell value being any month after January....
View 7 Replies View Related