startup

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

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.

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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