excel macro

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007-Macro

Excel 2007-Macro

resolvedResolved · Low Priority · Version Standard

Michael has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Excel 2007-Macro

Is there a folder that stores our saved macros?

RE: Excel 2007-Macro

i ;presume 2007 is the same as 2003?
you can click on tools, macros and visual basic editor and look at your project explorer and under "Modules" you will see the macros you have saved?
these may either be saved under the spreadsheet you are working on, or maybe in the PERSONAL.xls item.
have a hunt around to see where you save them and also notice when you save a macro, where it is being saved to.


 

Excel tip:

Hiding a worksheet in Excel

Want to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view?

You can do so by bringing up the sheet you wish to hide on your screen; then going to Format - Sheet - Hide.

It will not be immediately obvious that a sheet is hidden from view unless perhaps the sheet are still labelled Sheet 1, Sheet 2 etc.

To display the sheet again, you can go to Format - Sheet - Unhide on any of the other sheets in the workbook. A dialogue box will appear, allowing you to select the hidden sheet/s. Click OK to make the sheet/s reappear again.

View all Excel hints and tips


Server loaded in 0.08 secs.