Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion 2007

Raghav has attended:
Excel Advanced course

Macros

Can a recorded macro be edited?

RE: Macros

Hi Raghav

Thank you for your question. You can edit Macros in Excel 2007. To make this possible

Click Excel's Office Button (the ball at the left of the Ribbon)
Click Excel Options
In the categories pane, click Popular
Select Show Developer tab in the Ribbon
Click OK to close the Options dialog box

There will be a new Developer tab on the Ribbon. Clicking on this tab reveals the Macros button that allows you to run or edit existing macros.

I hope this helps - do let us know if you have any questions.

Kind regards,

Andrew

Wed 16 Feb 2011: Automatically marked as resolved.

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010

Here's how to move or copy sheets between workbooks in Excel 2010:

Open the sheet you want to move or copy then on the Ribbon click the Home tab. Click Format. Under Organize Sheets, select the option Move or Copy Sheet and then choose where you want the sheet to be moved/copied to.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.