Brian63
Veteran Member
- Joined
- Jan 8, 2001
- Messages
- 1,639
- Location
- Michigan
- Gender
- Male
- Basic Beliefs
- Freethinker/atheist/humanist
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.
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.