• Welcome to the new Internet Infidels Discussion Board, formerly Talk Freethought.
  • 2021 Internet Infidels Fundraising Drive
    Greetings! Time for the annual fundraiser.Sorry for the late update, we normally start this early in October. Funds are needed to keep II and IIDB online. I was not able to get an IIDB based donations addon implemented for this year, I will make sure to have that done for next year. You can help support II in several ways, please visit the Support Us page for more info. Or just click:

    I will try to track all donations from IIDB. Many thanks to those that have already donated. The current total is $550. If everyone dontated just $5, we would easily hit our goal.

Excel macro error

Brian63

Veteran Member
For my new job I am trying to create an Excel macro. Macros are something I am new to, but this should be a very simple one. I want to apply it to the “Personal Macro Workbook” so it functions every time I open up any Excel file. The macro steps would involve simply selecting several columns on the sheet which are extraneous for my job, hiding those, and then selecting cell A1 as the active cell. Then stop recording.

However, when I attempt to do so I get an error message. The following webpage illustrates correctly most of what happens:

https://www.excelvbasolutions.com/2021/03/personal-macro-workbook-in-startup.html

Near the bottom of that page I get a different result from what that page displays. Instead of having an option of “Addin: personal.xlsb” I get a message of “There are no disabled items.”. I am stuck.

So I am unable to create this macro at all. Can anyone help a tech-unsavvy person resolve this?

Thanks.
 

Brian63

Veteran Member
An IT nerd at work researched and believes he needs to give me special permission to have such a folder...errr...something like that. We are awaiting my manager's approval before making changes to my permissions/computer settings though.
 

steve_bank

Contributor
I periodically run into write permission problems with technical apps I use. I get can ot access a file or unable to open a file for writing errors.

Running the app as administrator often fixes the problem, I can do that as I own the PC. Sometimes I have to figure out which folder is causing a problem.

Windows is a complicated mess.

I would think you would not have a problem with Excel on your local PC user account.
 

Jimmy Higgins

Contributor
I periodically run into write permission problems with technical apps I use. I get can ot access a file or unable to open a file for writing errors.

Running the app as administrator often fixes the problem, I can do that as I own the PC. Sometimes I have to figure out which folder is causing a problem.

Windows is a complicated mess.

I would think you would not have a problem with Excel on your local PC user account.
Yes and no, the Personal workbook is likely in an area IT doesn't want employees screwing around in.
 

Brian63

Veteran Member
My manager currently is on vacation for the remainder of this week, and it will be a long while before she gets caught up on emails and such. Even while that is going on, this would be a low priority for her, but a minor helpful convenience for me. So there is no rush to get it done, if it were to be done. Still, she may be very wary of any employees having special permissions to create macros of their own.

I had a couple other ideas for the IT dude to consider. One would be to temporarily allow me to have those added permissions. So I could create that particular macro and then he would have the ability to remove my ability to create new macros after that (actually, I have a total of 2 macros in mind...the other would be to later UNHIDE those columns that previously were hidden, which is something we are required to do manually). Would that delete all macros from my Personal account though, or only remove the ability to add new macros? The former I want to avoid as it would defeat the purpose. The latter is fine.

The second idea would be for IT folks themselves to create the macros and then put them in each of our Personal Excel accounts (my coworkers would benefit from these as well).

I did not have any other ideas, but asked if he might have. No response yet from him. Any from anyone here?
 
Last edited:

Jimmy Higgins

Contributor
I'd say just ask for write access to the C:\Users\*user name*\AppData\Local\Microsoft\Excel\XLStart folder, and leave it at that, I assume that is the location of Personal.xlsm. All the other folders, not an issue.

Until then, just save macros in a standalone file.
 

Brian63

Veteran Member
We use Excel spreadsheets that are constantly new and changing and the macros would apply to all of them, so it would not apply to a single standalone file. That is why it would only be useful if it could apply to all past, present, and future workbooks.
 

Loren Pechtel

Super Moderator
Staff member
Excel should be nuked from orbit.

When spreadsheets get fancy like this they cause trouble. Excel is a road into quicksand.
 

Gun Nut

Veteran Member
You can save a macro in a workbook you use just to save your custom functions and macros, and then reference them in any other workbook. It is less elegant than just having them automatically extended into any workbook you open, like you are trying to do, but it will work.
 

Brian63

Veteran Member
In the particular instance for my job, it would only be worthwhile to have a macro that automatically extended across workbooks. It is difficult to understand though unless you knew more about the job and the role of the macro.
 
Top Bottom