1. C

    Custom Ribbon Strange Behaviour in Shared Workbook Saved in Maximized Window Mode

    Hello! I have gotten so much help from this board and I do not feel the greatest where my first contribution is in the form of another question/problem, but now that I am here, who know!? I will try and keep it short. I have built an Excel-based scheduling tool with a custom ribbon in a shared...
  2. PeteWright

    Excel 365 starts with error message "sorry excel can't open two workbooks with the same name at the same time"

    Hello everybody! As the topic title says I'm getting an error message each time Excel 365 starts (fresh restart, after Excel was closed). Maybe there's an issue with one of my Add-Ins, I cannot explain this otherwise. Any help appreciated.
  3. 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...
  4. 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...
  5. DarbyBrown

    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...
  6. 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...
  7. 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...
  8. 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?
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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 - 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...
  18. 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...
  19. 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...
  20. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back