YES. I know how to view the Macro in the VBA Editor.

I guess you just got to try this yourself to see what I'm talking about.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Maria

ToolsMacroMacros

Select your macro and "Edit"

Alternative................

Hit ALT + F11 to get to VBEditor

Hit CRTL + r to open Project Explorer.

Find your workbook/project and hit the "+" box to expand.

You should see a Module1.

Double-click on that to open it and see your code.

Gord Dibben Excel MVP

On Thu, 18 Nov 2004 13:01:12 -0600, "Maria K Brickl"
wrote:

I did a record macro to post a workbook to public folders. When I hit stop
and go to the VBA Editor there is no code. But if I assign this same macro
to a button. Then click on it it works. But I see no code and I need to
see
the code so that I can make an adjustment.

In the end I would like to be able to save a workbook as a certain name
depending on what is in certain cells and then post it automatically to a
public folder.

Any suggestions?