I'm working on a spreadsheet that was made by someone else at another company. My boss would like me to update it so that it applies to our current work. Problem is, there were command buttons at the top that were activated with some code to make them work. They won't work now that I've added some command buttons and I can't get the new command buttons to work. I need to be able to click on them and they sort by whatever they are labeled to do. PLEASE HELP!
Your Excel may have a different "Macro Security" setting.
Your "Macro Security" can be adjusted:
Tools, Macro, Security.
I highly recommend the "Medium" setting.
This will prompt you when an Excel file is opened that contains Macros to Enable or Disable.
If you choose a security setting of "Low" please be very careful as this will allow Macros to run without any notice, VERY DANGEROUS.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Macros are harder to understand than they are to create and use. Let me repeat "Macros are harder to understand than they are to create and use."
Here is the only understanding that you need. "they are used for repetive tasks" .
Now to the simple part of creating then using.
Get into your work and identify a task that you want to created macro for, Kapish? Just before you start on the task go into the macros screen and tell it to "create", then do your task. When through "push the stop button. Name the micro and save it. (the name may be the first step if so then give the darn thing a name, no big deal). The next time you are in the exact field where the identical task is going to be perforned you can call up the micro to run through the key strokes for you. Get ready for wildly unexpected results, with those understood you can go into the code and modify it. Or you can delete it and create anotherone that is cleaner. Keep doing this until you get the bugs out. By the way the once created micros leave a tag in the spreadsheet that alerts everyone that opens it to watch out for the dreaded micro you created.
Macro is a simple way to automate tasks in Microsoft Office programs. It allows advanced users to program or create their own commands in Office, thereby automating tasks. For example, a user might want to create a table with four values already in them. The user could create one, and then copy it, and paste it. However, when you restart your computer, that data is lost. Unless you open the old document and copy the table, you'll have to start all over again. Macros helps you do your tasks. By recording the table creation to a macro, creating the same table over and over is just a simple macro away.