xlstart

  1. M

    Need to change XLSTART location

    My company has completely locked down the C drive of my new laptop. I cannot copy my macro workbook to XLSTART. Is there any way to change the location of the XLSTART folder?
  2. 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...
  3. G

    personal.xlsb not automatically opening

    I recently upgraded to Windows 10 and the installation overwrote my old personal.xlsb file erasing all the macros I had stored there. Additionally, when I start Excel now the personal.xlsb file does not open. When I go to the XLSTART folder, the file is there. I open it from the XLSTART...
  4. C

    A new instance of Excel opens Book, Book1, Book2, etc. however with Book.xlsx in XLSTART I get 'locked for editing' (no network sharing)

    I've searched the forum on this issue and can only find instances of this error where network sharing is enabled; in my case there is no network sharing (i.e. the Server service is never started). You will be familiar with the behaviour on opening multiple instances of Excel 2010 where the new...
  5. S

    Book.xltx XLStart template settings not being used in excel

    Hello, Am having an issue in Office 365's Excel 2016 (v1702 (build 7870.2038)) I am attempting to have all new workbook / worksheets to use custom styles defined in Book.xltx and Sheet.xltx respectfully. Steps taken include: Create the styles, save as Book.xltx and Sheet.xltx respectfully...
  6. 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...
  7. C

    XLSTART issue (can't hide file)

    I've had a PERSONAL workbook (binary worksheet) on my work computer for about 3 years, used to store macro functions that I can reference in all files and has worked great. I prefer to have the PERSONAL file hidden when Excel opens, however for some reason Excel will no longer open if I try to...
  8. E

    Open macro saved on shared network drive

    Hello all! I have a workbook that users will be downloading/exporting from an external source. Once downloaded, I have two hotkeys that run two macros. I would like the location of the macro to be saved on the shared drive, so when a user hits the hotkeys, excel will still know to look for the...
  9. L

    My Macros are making my cry :-(

    Hi all, My macros are making me cry - it's awful. I accidentally saved some of them to "this worksheet" before I was told here that I need to be saving them to XLSTART. I've been doing that, but nothing is working... I don't know where XLSTART is, to see what's in there... I don't know if I...
  10. 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...
  11. E

    macros problems within excel 2007

    Hi, i'm working in excel 2007 with a workbook that contains macros that is used by an other workbook. This macroed workbook is in the XLstart folder. It is opened at startup of excel in a hidden window. The unhidden workbook is where i call the macros from the hidden workbook in the xlstart...
  12. S

    VBA code/variable? for filename

    Hello, I created a macro what makes in a cell a hyperlink of the filename and the path and copy the link to the clipboard. It works, i made a template of it and put it in XLstart "normal.xlsm". Now if i open excel and i make a new filename and save it on the place i want because of changing...

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