Enabling Macros – Excel 2010

If macros are not enabled on your copy of Excel, then GanttDiva will not work. Here are the steps required to ensure that macros can run on your copy of Excel of Excel 2010 and you can use GanttDiva to create your Gantt chart based project schedule.

Step 1 – From the File menu, select Options. You should now see the following screen:

Select the Trust Center page from the choices in the left panel. You should now see the following screen:

Click on the Trust Center Settings button and select Macro Settings from the choices in the left pane. You should now see the following screen:

Ensure that macro security is set to at least Disable all macros with notification. This is the setting I prefer, however it does mean that the first time that GanttDiva is started, you will need to enable macro settings for the file. On subsequent starts, macros will automatically be enabled for this file.

No comments yet.

Leave a Reply