Can't use macro - 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.

Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

you can find more information about macro and usage of macro from
Automate computer tasks easily with macro software

This lens is not a true macro lens. It provides a magnification of 1:2 only, while true macro lenses provide 1:1 (life-size)magnification. So you won't be able to do very close macros with this lens. This lens has a Macro switch to enable you to switch to the Macro or normal mode.

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 !

After you record your macro do the following.
Open the excel file contains the macro. Go to tools and go to macro and click on macros. Select the macro you wish to add the close operation. Click on Step into... This will open up the visual basic editor. In the code window, at the bottom row you will see End Sub. Right before that row, type workbooks.close
Save the macro by clicking the save button. And you can run your macro to see if it works. I tried, it does :) Good Luck :)

Press the macro button once to get it to display the Macro Mode sign. Press and hold it after that to get it into Super Macro

Once you are in Super Macro, you can't move the lens so you MUST use the Manual Focus (MF) button that is located right above the Macro toggle button. While holding the MF button, use the 4 way directional pad to focus in and out. Press the Up and Down to focus.
You have to be REALLY close for Super mode.. less than about 6 inches

Macros are a timesaving feature that allow you to record a sequence of actions that you do in excel, and replay them back later.

You give each macro a name, and you can invoke them later, and Excel will "do" whatever it is you did when you recorded the macro.

To record a new macro:
1) Open Excel
2) Go to Tools->Macros->Record New Macro...
3) Type in a name for your macro and hit OK

(A new toolbar will popup with a "stop" button on it. Excel is now recording everything you do)

4) Do something, like, for example, select some cells and make them bold.
5) Click the "stop" button.


Now your macro has been recorded! You can play it back later by:

1) Open Excel
2) Go to Tools->Macros->Macros...
3) Select your macro from the list
4) Click "Run"

The actions you performed earlier will now be executed.



-------


Macros are written in Visual Basic for Applications, or "VBA". It is a programming language which uses the Excel Object Model to perform various actions. You can edit and create custom macros by writing the code manually in VBA. To do this:

1) Open Excel
2) Go to tools->macros->macros...
3) Select an already existing macro
4) Click "Edit"

(The visual basic editor will open, showing you the code for your macro)

At this point you are writing a program in Visual Basic. To learn how to edit macros, you need to learn visual basic, as well as the specific quirks related to excel macros in visual basic.

Recording a macro, and then using it as a template while you edit it is a common trick for making macros manually more quickly.

If you are not familiar with VB, I would not suggest attempting to edit your macros in any but the most simplest of ways. If you're brave, you can try to learn about editing macros in VBA here:

http://www.anthony-vba.kefra.com/

Dear ROCKY open Tool Menu-Macro-record new mecro-give the macro file name like rocky-do your work when you finish your job then stop button mecro and save it . next day when you do same job on other file then again open macro and run your macro file and get same job on your new file

Make sure your camera isn't zoomed in (full telephoto) The camera can't handle both full zoom AND super macro. Don't forget super macro goes from Zero to 20cm from the lens. Zoom completely out and you should be able to see something within that range. The biggest complaint I've heard about the S2 IS is if you take closeups of bugs the chances of the bug crawling onto your lens is pretty good.:-) Be very carefull of blocking light with the lens at extreme closeup too. Although the flash squelches well to allow for closeups it can leave a nasty shadow. If you're really serious about macro you'll find a ring flash would come in handy. BMW