personal.xlsb

  1. adrienne0914

    PERSONAL.XLSB file issue

    I had to move my personal.xlsb file to another folder because of a conflict with IBM Cognos. The problem is that my macros don't show up right away in the macro menu. I've specified to open all files in the drive where it's located at startup. I've listed the drive where the file is located as...
  2. M

    OneDrive AutoSaves! Prompt user on opening every file to save a copy

    I use OneDrive for most of my files since I need access from to them from multiple computers. I have several files that I frequently opened just to change and save with new file name, keeping the original intact. If I forget to do this after a few edits, autosave kicks in and my original file is...
  3. B

    Seeking Effective Approach to Using Personal.xlsb on Multiple Machines

    I'm using Office365 on several machines that all run Windows 10 Pro. I login to those machines using a Microsoft Account and I have all the syncing options that I can find set to sync. My OneNote stuff syncs as do my spreadsheets. Changes on one machine show up on another machine even in the...
  4. 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...
  5. 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
  6. 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...
  7. 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, _...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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"...
  15. 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...
  16. 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...
  17. 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?
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top