28-80 how to set for macro - Nikon Cameras

From the excel help file

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click Trust Center, click Trust Center Settings, and then click Macro Settings.
3. Click the options that you want:
   • Disable all macros without notification Click this option if you don't trust macros. All macros in documents and security alerts about macros are disabled. If there are documents with unsigned macros that you do trust, you can put those documents into a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system.
   • Disable all macros with notification This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis.
   • Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification.
   • Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. This setting makes your computer vulnerable to potentially malicious code and is not recommended.
   • Trust access to the VBA project object model This setting is for developers and is used to deliberately lock out or allow programmatic access to the VBA object model from any Automation client. In other words, it provides a security option for code that is written to automate an Office program and programmatically manipulate the Microsoft Visual Basic for Applications (VBA) environment and object model. This is a per user and per application setting, and denies access by default. This security option makes it more difficult for unauthorized programs to build "self-replicating" code that can harm end-user systems. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. To turn on access, select the check box.

http://office.microsoft.com/en-us/excel-help/enable-or-disable-macros-in-office-documents-HA010031071.aspx?CTT=5&origin=HP010096919#BM12

1. Click the Microsoft Office Button , and then click Access Options.
2. Click Trust Center, click Trust Center Settings, and then click Macro Settings.
3. Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. This setting makes your computer vulnerable to potentially malicious code and is not recommended.

I have a Sony W120 and had the same macro problem, tried all the "solutions" mentioned here without result. So I pressed the "Home" button, went to "Settings" (last menu item at right), then "Main Settings", and used the "Initialize" functio. Problem solved !

Your lens is the limiting factor to take macro photos, the kit lens provided with you camera won't focus very closely, nor it will have decent magnification. There are special purpose macro lenses which can stretch up to and over $1000 for a decent quality one. Tamron's 90mm f2.8 is probably the best value one.

A tripod will be of benefit too, as it slows down the process, so you think about your composition, use manual focus and a small aperture for better depth of focus (field).

I have a Sony W120 and had the same macro problem, tried all the "solutions" mentioned here without result. So I pressed the "Home" button, went to "Settings" (last menu item at right), then "Main Settings", and used the "Initialize" functio. Problem solved !

Running a macro is simple: Select Tools | Macros, choose Macros from the resulting submenu, select the macro you want to run, and click Run.

Page 16 of the user manual explains how to set up the camera for the macro mode. If you are using regular macro mode then you would also need to set the flash mode to off if you do not want it to fire automatically (page 15 of the user manual refers how to disable the flash). If you are using the super macro mode then the flash would be set to off by default.

if the form "products" really exists, then your office 2007 security settings are not allowing to load macros. Try the following settings:-

Office 2007 has some security settings disabled by default to prevent any harm to your system.

go to trustcenter settings(click the office button at the top left of the office 2007 screen then click Access options, then select Trustcenter, then click trustcenter settings.)
In trustcenter settings, select message bar then select "Show the message bar in all applications when content is blocked" radio button.

Then from macro settings ,make sure to select "Disable all macros with notification" . Click ok twice to close the settings windows and try opening the file again.

Good Luck

Hi motilal

Follow these steps to create multiple macros

Click the Microsoft Office Button , and then click Excel Options.
In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

Note The Ribbon is a component of the Microsoft Office Fluent user interface.
To set the security level temporarily to enable all macros, do the following: On the Developer tab, in the Code group, click Macro Security.


In the Macros Settings category, under Macro Settings, click Enable all macros (not recommended, potentially dangerous code can run), and then click OK.

Note To help prevent potentially dangerous code from running, we recommend that you return to any of the settings that disable all macros after you finish working with macros.
Open the workbook that contains the module that you want to copy and the workbook that you want to copy the module to.
On the Developer tab, in the Code group, click Visual Basic.
On the View menu, click Project Explorer .
Drag the module that you want to copy to the destination workbook.

Regards,
TheAssembler

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.