Question about Microsoft Office Standard for PC

1 Answer

Macros Command Help

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! Thank you, Beth

Posted by on

  • flowerpower Oct 05, 2007

    why is that dangerous? it kept saying that on the tutorial, but no explanation why.

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 27 Answers

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.

Posted on Oct 05, 2007

  • CNewton2
    CNewton2 Oct 05, 2007

    Because someone may send you an Excel file with Malicious code that can delete / rename / goober up your hard drive. There are old school DOS commands that can be activated with code without the users knowledge.

×

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Please i need free auto cad 2010 and MS excel 2007 software to download


For Excel, use the OpenOffice free software (http://www.openoffice.org/) or Google Spreadsheets if you don't need high powered macros.

Autocad download is here:
http://usa.autodesk.com/adsk/servlet/pc/index?siteID=123112&id=13779351

Aug 04, 2010 | Computers & Internet

1 Answer

I'd like to get some examples using macros for the Remote MX-950


Your best bet for the best help is at www.remotecentral.com That's where the Pros hang out.. I do Crestron,Lifeware,RTI and Logitech, I don't do too many Universal's. They have a whole forum dedicated specifically to the MX remotes. Hope this helps

Jun 23, 2009 | Audio Players & Recorders

1 Answer

How to delete the nulls cells?


Try create a new Workbook (file) and then copy only the 10x200 cells from the NULL'ly spreadsheet. Unless you have macros in the nully one, it should be resolved by copying the needed cells to blank new file.

Apr 17, 2009 | Microsoft Computers & Internet

1 Answer

Need a link


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.

Jun 20, 2008 | Microsoft Computers & Internet

1 Answer

I need to import data from access into excel where one column go into one worksheet and other into next worksheet


Acess will only export the data into an Excel spreadsheet with each element of the record going into a sperate column.

You can record macros to get the data to go where you want it to go on the spreadsheet.

Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

EXCEL


I have solution for your second problem.
You just need to use macros to protect all the sheet at the same time. Just open "Macro>Record new Macro" to insert new macros to your files.

This will save some your valuable time.

Jan 09, 2008 | Computers & Internet

2 Answers

Need to Know fully info about Macros


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.

Sep 26, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

99 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2993 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...