personal

Using Version Excel Office standard 2010 version 14.0.4760.1000 (32-bit) on a Remote Desktop environment. VBA skill level: Novice (recorded my first macro to do a text to columns split using Char(10) last week and wrote a Clear.contents macro 2 weeks ago) please be gentle lol. I have 1...

Hi, Any ideas for this strange problem that's happening. I've got an excel personal file that works fine (able to run all the macros i have in it) when i open excel normally. However when it's opened by another program that drops some data into the first sheet the macros that are available...

I'm using Excel 2013 and have created multiple macros that I have as quick access buttons. Last week my personal excel file stopped opening upon opening excel. The file is not hidden or disabled.. I have searched the Users >appdata file folder I've seen as another common solution, but don't...

Hi - I am new to macro's and recently recorded one but when I ask a colleague to run they tell me that its in my Personal Workbook and they cant run it Is this something that can be resolved please in Excel 2010

I copy a macro to a module in my personal macro workbook. Is there a way to save that change immediately, without having to either open the personal macro book and saving it or save all open workbooks and wait for the question want to save your macro personal book. For some reason I often make...

Hey, Whenever I try to assign a keyboard shortcut to my personal macro's they never work.. it sticks to it when I go back in to change the key however when I try to perform it it doesn't work. Is something blocking this from my settings as non-personal macros work fine? Thanks,

Excel 2016 Trying to simply use a Userform in Personal.xlsb (binary) Personal workbook but when I run the personal macro to show the form, it throws up popup, "Object Required" Code I'm using is simple: Sub showxlst() UserForm1.Show End Sub Yes, the form is called UserForm1 So what am I...

I am unable to run my personal macros and also cannot view or edit them in visual basic editor; even though I can see them in the Project window. Also, the macros do not show up when I'm in Excel and click on View Macros. The personal workbook macros ran fine earlier this morning but stopped...

I am having issues with opening spreadsheets after editing/creating a macro. It opens a 2nd blank window when opening the file, if I attempt to close either one, it closes the non blank one regardless. I have researched and I do not have anything in %appData%\Microsoft\Excel\XLSTART\ as far as...

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, I am using Excel 2007 at work and my Personal workbook has disappeared. I have checked the XLSTART folder and the file is there, I can manually open it and it works. It also works if I open a new/blank excel document. However if I open a file I have created/saved, then the Personal...

Hi guys, Windows 7 user. I’ve setup personal.xlsb for one of my colleagues some time ago. Since then, whenever she tries to open excel it says that: “Excel cannot open the file ‘~$PERSONAL.XLSB’ because the file format or file extension is not valid. Verify that the file has not been...

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

I was running a macro, and all the sudden I was asked if I wanted to save the file I was working on. I said "No" to saving that file. Then, Exsmell closed out every open workbook including the Personal Macro Workbook. I did a file search, and the most recent version was yesterday. I have...

Hi, ever since I added a macro to my personal workbook everytime I open excel by clicking on the excel 2010 icon the Personal.XLSB is opened instead of New blank workbook. I deleted the module but it didn't solve the problem can you please help. Thanks, somone

Hi, I have a master timetable for interviews which involves 6 assessors and 6 candidates showing the room, the activity, the assessor and the candidate at a particular time. What I would like is the ability to take the master timetable and automatically be able to generate 12 personal...

Recently changed machine, but still running XP with Office Professional 2003. I've recorded a couple of macros but now whenever i open a file, or try to run the macro in a brand new workbook, it automatically opens the PERSONAL.xls file. I've checked the VB script and there is nothing in...