1. M

    How to create a macro add-in with customized ribbon?

    Please Help! Hello, I have a VBA module with 50 + macros located inside of personal.xlsb. I have customized an elaborate ribbon that links to all of these macros. I am trying to port this setup into a new workstation. I just made a copy of the personal.xlsb and put it in the xlstart folder...
  2. M

    VBA - run code on close of all workbooks (PERSONAL.xlsb code)

    Is it possible to create a code in the Personal.xlsb file that runs when ever you close excel? almost like the save message on close of excel? I want to run a code that disables an addin everytime excel is closed. please help
  3. T

    Personal.xlsb visible but not opening.

    Hi all. I hope you can help me as I am having a bad, bad day I was editing a long macro earlier in VB editor and when I returned to it, my macros have all disappeared. The PERSONAL.XLSB file is still visible in C:\Users\tt*******\AppData\Roaming\Microsoft\Excel\XLSTART which I hope is a...
  4. Dr. Demento

    Sub quits on Dropdown.OnAction assignment

    I'm running a sub from PERSONAL.XLSB that assigns a DropDown to the active sheet. Below is how it's being assigned. Dim ddFilterDropDown As dropdown ' Add a new filter dropdown Set ddFilterDropDown = rngDest.Parent.Shapes.AddFormControl(xlDropDown, _...
  5. J

    Worksheet Reference using Personal.xlsb

    Hello: I am building a macro that works with multiple other files. It is contained in the personal.xlsb file. However, when I refer to the worksheets in the other files, I'm able to use the Name property -- for example "New Sheet" -- without a problem. But when I try to use the CodeName property...
  6. I

    Referring back to calling spreadsheet from presonal.xlsb

    I have a bunch of macros that I keep in a personal.xlsb spreadsheet so they are avaialble to all of the workbook I use. When in a macro in personal.xlsb, I refer back to the calling spreadsheet using activeworkbook. That works as long as I only have 1 spreadsheet up but if I am using excel and...
  7. Small Paul

    PERSONAL.XLSB has Disappeared

    Hi For some reason, I can no longer see my PERSONAL.XLSB file which holds ALL my macros. It was working this morning but then stopped! When I try and open Excel I get the warning "Excel is running into problems with the .....personal.xlsb add-in. If this keeps happening, disable the add-in...
  8. B

    PERSONAL macro workbook not opening

    Hi, I have an issue where if I open excel as a blank workbook, my PERSONAL.Xlsb file opens in the background as it always has. However if I open any other workbook, that file no longer opens. This has only started to happen in the last couple of days (think I installed some windows updates) I...
  9. X

    Calling a macro with a variable from “Personal.xlsb”

    I have a macro in Personal.xlsb called Public Sub Get_Name(shName As String) When I use below sub to call Get_Name from Personal.xlsb, I get an error at the Application.Run "Personal.xlsb!Get_Name(shName)" Public Sub Set_Name() Dim shName As String shName = ActiveSheet.Name...
  10. P

    Thinks binary file is open

    I set Excel at startup (via File->Options->Advanced->General) to open all files in a folder F:\Excel Startup, which contains the binary file Personal.xlsb and nothing else. Recently I get this error trying to open any Excel file - A document with the name 'Personal.xlsb' is...
  11. D

    can't create a button from Personal.XLSB Excel VBA

    Hello, i have a strange issue with Personal.XLSB where it won't let me create a button from there. if i use the code below within the File instead of Personal it works every time. the code i am using is: ActiveSheet.Buttons.Add(47, 43, 41, 35).Select Selection.Name = "Test"...
  12. B

    Excel crashes when Personal.xlsb is hidden

    Having an issue with Excel crashing when Personal.xlsb is hidden. I am currently running Office 2016 on Windows 7. Have several macros in the Personal.xlsb file that are hidden so when I open excel I get a blank sheet but can still access the macros. The problem. I am switching to a new...
  13. S

    VBA - Double click and change colour

    Hi There, I'm newby so please forgive my stupid questions. I got this code from internet (maybe from this site) which works perfect in PERSONAL.XLSB. My intention is to use GENERAL for all open excel file where PERSONAL.XLSB contain this code: Private Sub Worksheet_BeforeDoubleClick(ByVal...
  14. M

    Need my Personal.xlsb saved on a network drive instead of c:\\XLSTART - Possible?

    Need my Personal.xlsb saved on my network drive as we are required to use network drives for all files. I tried moving my file but it does not show up under View Macros. Is this possible?
  15. B

    Loop through folder

    Hello, I have two macros in my PERSONAL.xlsb, that does some formating and stuff to opened .csv file and autoclose it to certain location. However, since i started to operate with multiple files so i would like to ask if someone has some macro that does 1.) open file 2.) run macro (which in my...
  16. L

    Personal.xlsb Can't find project or library

    Hi, My Personal.xlsb file was working absolutely fine yesterday, now today it doesn't automatically open when opening Excel although it's in my xlstart folder and when I try to manually open it, it brings up a Can't find project or library error message and then crashes. I've tried to locate...
  17. D

    Personal.xlsb loading after selected working workbook

    When I first decided to use a personal.xlsb with Excel 2016 in XLSTART to store my macro it would load before I opened the workbook I wanted to work on so it was hidden and the workbook I needed to work on loaded last and so it was active. Fine. Recently, behavior has changed and now...
  18. D

    Workbook with vba code only

    Personal.xlsb contains code only, and no visible worksheets. Can I do that with another workbook? Here's why I want to. I developed a set of macros that replicate the old F4 function of repeating a custom search. I may want to share the code, and recommend that the code be placed in...
  19. T

    i used all the letters for CNTRL+SHIFT+letter how to write more macros?

    I am using a personal.xlsb and load it every time I run my project. I activate the macros by using cntrl-shift+letter. I have already more than 26 macros connected with the specific project. How can I write more new macros? And run them from the same personal.xlsb?
  20. 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...

Some videos you may like

This Week's Hot Topics