personal

Hi, I been researching this today but i am getting stuck. I would like to run a Sub () in my personal workbook called Sub T205 () on Fridays at 6pm eastern time. Not sure what Application.Ontime to use and where to put it into. Can I put it into my personal workbook to run that sub? Do I have...

Hi, I wrote the following code to loop through data column for keywords such as "personal" or "fraud" and copy rows with these keywords to a separate tab. The problem is that my code does not work when the keyword is within the phrase (i.e. "personal expenses"). Is there quick fix for that...

Saving personal macro book in VB Editor by: Select "File" then "Save" Personal.XLSB. However when going to the folder for the personal macro book: C:\Users\jjohn\AppData\Roaming\Microsoft\Excel\XLSTART The saving date of the personal macro book has not been updated to todays date. I some...

Hi, I have a macro set up in my personal workbook but the Personal workbook file is really annoying me. Every time I open an excel file a pop up says the personal workbook is locked for editing. I can only open the personal workbook as a read only meaning it can't be edited/saved etc. I have...

Suppose I have some special conditional formatting rules set up that I would like to be able to use in ALL of my Excel documents, whether they be .xlsx or .xlsm. Is it possible to create such a rule and have it accessible to any document that I open? If so, how? Would you be able to provide...

I wrote a VBA macro to manipulate some data in a tab with a module in my Personal Workbook. Everything works great and fast. Now I'd like distribute this to my team, so I do my normal steps: Create a macro-enabled workbook. This is completely empty. Add a module. Paste the exact code from...

Is it possible to import other macros in the ribbon, than the standard ones from the personal macro book. The macro should remain in the ribbon. (I have some code in one VB Module saved on my drive). What is the easiest way of opening it in a standard way? If it could always be in the ribbon...

I just started creating some functions, not sure why I ignored this functionality but they are really handy. I had a very simple one I figured I would just port over to the personal workbook and be able to use, but it seems functions are not as functional as macros, in that I can't access the...

Hello, I'm sure this question has been asked and answered, but apparently my thought processes don't come up with the right search words. So, I apologize in advance. The problem is I have a new computer (actually, a new one that crashed and burned and they had to replace everything). I did...

Hi I am trying to put a macro on my work colleague's MAC. We are running Excel 2016 but when I try to record a macro, I get the following error: Personal Macro Workbook in the startup folder must stay open for recording. Any ideas on how to solve this?

I have some custom functions that I would like to be used in every excel file I open (if it isn't already in there). I know I can use my Personal Workbook to do this, but I frequently send/share spreadsheets with other people I work with and it is not feasible to copy the functions to...

If I have data like this, pre-pivoted: <tbody> ID Q1 Q2 Group 1 Explore Not at all 1 2 Personal Somewhat 1 3 Take Very 1 4 Obtain Very 1 5 Obtain Very 1 6 Take Not at all 1 7 Personal Sucessful 1 8 Improve Successful 1 9 Obtain Very successful 1 10 Obtain Not at all 2...

Hello everyone, Sorry I'm a total newbie to advanced excel offers and so I'm sorry if this is the wrong forum. I am starting work at a company and just got my schedule. The scheduler sends us a large monthly schedule listing what project (eg Facebook, Twitter) an employee is working on every...

I’m ashamed to say I’m very late to this party. I have the same macros in many workbooks, and don’t want to delete them if I don’t need to... If I have a macro in a workbook that has the same name of a macro in my personal macro workbook, will I run into any conflicts or gotchas?

Hi guys, I have a little experience in Excel and Visio. It is very easy for me to hide content. In Excel, I can hide or even delete rows and columns that contain personal notes. I can either hide columns/rows and extract a pdf or Save As and then delete rows/columns. In Visio I can play with...

Howdy, I have some personal macros that only work if they are copied to the worksheet macro. Unfortunately I cant store them as a worksheet macro as this is imported from another macro and renamed to override the filename of an older version. Twofold question, can i make a personal macro work...

Hi - I have a complex sheet with at least 100K entries on it with following columns:- Name | Work Email | Personal Email Work Email & Personal Email column have many duplicates on it. How to remove it via excel formula? So that original data is not disturbed please. Regards

The below simple code run from personal will return a value of 1 regardless of the number of sheets in the workbook. The same macro copied to a module in a workbook returns the correct number of sheets. Additionally all of the macros in my personal folder that use sheet counting code do not...

Hello again In the past I've had (and my co-workers, too) a weird problem where we'll go to use a macro and our entire Personal Macro Workbook is just gone! It's been VERY rare and I was told how to fix it: Open a blank sheet, click "record macro", Select for it to go into Personal Macro...

Hello, I use multiple systems in my office, some of them have 2007, some have 2010, some with 2013 and one with 2016 Excel. I tried to find the Developer tab in all but i could find in 2010 and 2016 only. Second, I could find personal. xlsb file in 2016 only not in any other version. Could...