startup

  1. E

    XLSTART startup folder in Citrix Virtual Desktop

    I constantly change and save my default Excel template in: C:\Users\dmalfoy\AppData\Roaming\Microsoft\Excel\XLSTART Does anyone have experience changing the default Excel template in a Citrix Virtual Desktop? I put in a ticket to my IT department and their response was clearly that of a deer...
  2. JTL9161

    Macro at Startup

    I have the below macro in the workbook startup to ask if I want to run the macro in the workbook. Private Sub Workbook_Open() CarryOn = MsgBox("Do you want to run the Macro?", vbYesNo) If CarryOn = vbYes Then Application.Run Macro:="holding2" End If End Sub After I click "YES" it tells me the...
  3. D

    Excel seems to open whenever it wants to.

    I am running windows 10 and when i am in another program (it doesn't matter what program), excel decides to open. There is no pattern of what is running on my computer, or any timing. It may start up in the middle of a game, or any other application. I can shut it down and it may start again...
  4. S

    Minimise the workbook and show a Userform

    I'm trying to get Excel to show a Userform (frmControl) at startup, but with Excel minimised. Having Excel minimised is not a mandatory requirement, but aesthetically it would be nice! frmControl is a sort of function selector, and a code representing the function eventually requested by the...
  5. H

    Saving VBA references between startups

    Hi. I am referencing Microsoft Scripting Runtime in my VBA code because I use dictionaries. However, this reference reset after every startup. How can I retain this between startups so that I only need to activate it once? Or better yet is there a way to do this inside the code similar to...
  6. N

    Hide Ribbon and menu on startup

    I'm trying to write some code to cause the ribbon to disappear and also try to get the menu to disappear on startup. I can get 'CommandBars.ExecuteMso "MinimizeRibbon"' to work just fine anywhere EXCEPT the WorkBook Open event. Any ideas for this and to hide the Excel menu on startup?
  7. O

    creating shortcut of current excel file in startup folder using VBA - getting error saying can't save

    I've created the following macro (from bits and bobs on forums) to save a shortcut of the current file in the startup folder of my computer, if i just manually create a shortcut it works so i know i can edit this folders contents but when i run this macro it produces and error about not being...
  8. C

    Blank workbook on Excel startup stays open

    Normally, when I used to open Excel, a blank workbook is opened along with Excel, and if I do nothing to this blank workbook and then open an existing file, that blank startup workbook is discarded automatically upon the new file opening. I recently updated to Version 1708 (Build 8431.2094) in...
  9. D

    change the language at startup Commsell Console

    Hello, how can i change the language on the comsell console ? now it starts with german language and i would prefer the comsell console with english language. on which part must i make the settings? I have watched some language startup videos also I'll use the simpana 9 with SP14. best...
  10. C

    Apply Excel theme or default shape upon opening any Excel workbook

    Our executives get excel documents from many sources. They want to change their default shape background from blue to blank. I have read how to: 1. Set the default shape, but unfortunately its only for the current document(many sources of files) 2. Set new templates - only work if they...
  11. D

    Macro Workbook not showing Macros is View Macro List

    Hello to all you great minds out there, I have a macro workbook .xlsb that my company and I use everyday all day. I have it saved in a shared folder so everyone has their excel startup with it. Most computers are fine, but some do not show macros in the View Macros List. Everyone has Excel...
  12. R

    Excel has stopped reading personal.xlsb at startup

    To my complete surprise, Excel seems to have stopped reading the personal.xlsb at startup, giving me a dreadful " Oh ****" shock when I went to use a macro and found that there were non showing when I clicked on "macros" in the ribbon. I have found that if I manually open...
  13. S

    Excel 2013 - At startup, open all files in: only works first time

    Afternoon all, I've just upgraded to Office 2013 and I'm trying to get to grips with it. Since Excel 2003, through 2007 and 2010 I have created and used standard templates for new workbooks and sheets which I store in a specific location. Using the "At startup, open all files in" option in the...
  14. N

    Startup Folder Issue : Stop working "randomly"

    Hello community! French Intern in Vietnam here. Received a lot of help from this forum to build my production planning, and now I need your help! In order to fill a database (product data), I want to have a macro running from PERSONAL.XLSB from 2 computers. This is supposed to display data in...
  15. R

    To Extract Specific Information from a Webpage or Page Source

    Hi Guys, I'm trying to extract the website url and the country name from a webpage which is like this - www.xyz.com/startup/startup-name-1234/ So, everytime startup name & the number at the end of the url changes and it's recurring. Manually I did change only the number at the end of the url...
  16. B

    VBA Code in Workbook_Open Prevents Double Clicked Excel Workbooks from Opening at Startup

    I have some code I placed in the Sub Workbook_Open in an xlsm file which is placed in XLSTART folder. The code executes properly when Excel is opened. Problem. If any code is in the Sub Workbook_Open, and the user double clicks an Excel Workbook and Excel is CLOSED, the workbook will open, the...
  17. C

    Persistent Failure of PowerPivot Load at Startup with Windows XP

    Hi ... PowerPivot consistently refuses to Load at Startup with Excel 2010 (32-bit) on Windows XP. At least 80% of the time, I have to navigate thru File:Options:Add-Ins:Com Add-Ins : Go where I find the Power Pivot for Excel option unchecked. Checking it and then clicking OK usually causes it to...
  18. Grizlore

    This code should hide all sheets apart from one [Could someone have a look plz]

    Could someone have a look at this code and see if you can spot what the problem is please? I intend this to on-shutdown hide all sheets apart from the one named "LOCKED" and on-startup, hide "LOCKED" and show all the other. It works if there is a sheet names "Sheet1", if not it doesn't...
  19. A

    How to make Excel 2011:Mac Launch Faster?

    I've tried the trick of removing any duplicate or corrupted fonts. Are there any other steps I can take to make Excel 2011 for Mac launch faster? I recall there used to be an "Office Helper" or some program that was set to launch on computer startup and run in the background, but that was years...
  20. CaterinaAnna

    Personal Macro Workbook does not open

    Morning All I have just tried to run a macro from my Personal Macro Workbook only to find it had not opened. A little investigation showed that it is still available in the correct directory, but it only opens if I open Excel as a separate stage: if I directly open an existing workbook, then...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top