personal.xlsb

I have a personal.xlsb file with a couple macros in it (no start up macros), and Excel won't open files I'm trying to click on to open but rather just opens excel to the hidden personal.xlsb sheet and never opened my desired file. I'm sure it must be a bug, is there anything besides deleting...

I am new to vba and macros. I saved all the macros I created to personal.xlsb file in an attempt to be able to replicate them at a later date. I then realized that this rendered the macros unusable to the various users of the workbooks on other computers. Can I export the macros to a place on...

Hi people. Do you like to share your PERSONAL.XLSB? Here is mine: Option Explicit Public Function sum_range(my_range As Range) As Double Dim cell As Range sum_range = 0 For Each cell In my_range sum_range = sum_range + cell.Value Next End Function...

Hello friendly helping people, Currently I am working in a German Excel, and thus the shortcuts are all confused. Howered, I need to restore the Ctrl+V shortcut for filling values in a column, because I need it badly :) I have tried to record a macro and save it to my personal.xlsb, but it...

Hi all, I have a hidden workbook called PERSONAL.XLSB located in C:\Users\xxxxxx\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB, that way I can store macros in that workbook that will then be available for all other workbooks I open. I work alot with an ERP system where the export comes...

Good day, I am working on a Macro for one of my coworkers that should delete duplicate rows based on Social Security Numbers in Column A. Right now, I have it deleting the duplicate row, but I need to add a condition that if one (or both) duplicate rows contain data outside of Column A's SSN...

Hello, My first post here. I've seen variations of this post on the forum but referring to Excel 2010, and without a solution I can use. I'm now working with a third party application which can send any output, from any part of the system, to Excel (i.e. not always in a fixed layout). I have...

How do I activate/access sheets by codename from the Personal.xlsb I want it to work for 2 scenarios: 1) Recently downloaded Excel report in the temporary folder, with one sheet, Worksheet name and codename are both sheet1. 2) Workbook has been saved and the worksheet name has been changed...

A colleague of mine is currently having an issue with their Personal.XLSB file which is used to contain many macros that are frequently updated. When they open Excel (2007) the Personal.XLSB file is loaded from the directory: C:\Program Files\Miscrosoft Office\Office 12\XLSSTART and they can...

I recently had a virus on my computer and had to replace it. I had a ton of macros saved in my Personal.xlsb workbook, so I exported those modules and have now imported them to the new Personal.xlsb file. Now for some reason those macros no longer work in other files. Most of them are basic...

We recently changed PCs at work. Generally, all of my files are stored on a network drive so access to those file still works. However, I noticed that I seemed to have "lost" many of my macros and VBA codes. It seems like these codes were stored in the PERSONAL.XLSB file that is stored in the...

Hi, I have Windows 7 and office 2007. Out of the blue, when trying to save a macro on personal workwook, Excel gives me the following message: personal workbook must stay open for recording a Marco on personal workbook. I've read previous thread, and tried the proposed solution...

Hi all,</SPAN></SPAN> I have a personal.xlsb file where all my macro’s are placed. Right now it is stored in the standard location; </SPAN>C:\Users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB. </SPAN>The problem is that when I want to work from home, I have to open my excel from a...

I'm trying to get the names of the sheets in an open workbook using the code below. It's not returning the workbook's sheets, it's returning the Personal.XLSB's sheets. Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets Debug.Print ws.Name Next ws I tried using...

A question has been posed to me that is a little beyond my scope of familiarity. A coworker was wondering if it would be possible to have a sort of constantly-update-add-in for all the networked computers in the office, so that all of the users could have access to his macros, and wouldn't have...