Jessica has attended:
Excel Intermediate course
Excel Advanced course
Word Intermediate course
Word Advanced course
Effective Budgeting & Beyond course
Macros
Hi
I have created a macro to order the s/s by department and then sub-total the departments.
I have to do this each month with different amounts of entries (same columns) but when I tried to use the macro on another s/s it would not run.
WHat have I missed?
RE: Macros
Hi Jessica,
Thank you for your post. It sounds like you're OK with getting the macro to run in the sheet in which you recorded it. If you wish to run a macro in any sheet, you will have to record a new macro.
It is important here to select "Personal Macro Workbook" in the "Store Macro in" section of the Record Macro window before you start recording it.
Doing this will enable you to create a shortcut button in your quick launch bar which can run the macro in any sheet you open.
When you assign a button to the macro, look for the "Personal" macro in the list.
I hope this is helpful.
Kind regards
Marius Barnard
Trainer
Best STL
RE: Macros
Hi Marius
I am trying to delete the macro to start again and i am getting a message
CANNOT EDIT A MACRO ON A HIDDEN WORKBOOK. UNHIDE THE WORKBOOK USING THE UNHIDE COMMAND.
Can you help please
RE: Macros
Hi Jessica,
Hopefully, the following steps will help:
Open the workbook that contains the macro that you want to delete.
If the macro that you want to delete is stored in the personal macro workbook (Personal.xlsb), and this workbook is hidden, do the following to unhide the workbook:
On the View tab, in the Window group, click Unhide.
Under Unhide workbooks, click PERSONAL, and then click OK.
You can then delete that workbook.
If this doesn't help, try the following:
In Excel, press Alt+F11 to activate the Visual Basic Editor.
In the Project Explorer on the left hand side, you'll see (among others) VBAProject (PERSONAL.XLSB).
Expand this until you see the individual modules under Modules.
If you want to remove ALL modules, right-click each module in turn and select Remove <modulename> from the context menu.
If you want to remove one or more specific macros, double-click each module in turn and look at the code. You can remove a macro by deleting its code (from Sub ... up to and including the corresponding End Sub).
When you're done, close the Visual Basic Editor. Don't forget to save the personal macro workbook when prompted.
I hope this helps.
Kind regards
Marius
