Gord,

I did not 'create' a macro as such. What I attempted to do was copy the
existing Menu Command 'Hide Sheet' to a macro button. 'fileA.xls' was open to
'Sheet 1' at the time I created this macro button.

What I ended up getting was a modification to Menu command 'Hide Sheet' that
tries to first Open 'fileA.xls' and then hide 'Sheet 1'. I cannot get the
'Hide Sheet' command to work generically anymore. I do not have access to
this code (under lock of a MS password, I think).

Does this make sense. Sorry, using Excel 2k.

"Gord Dibben" wrote:

Dave

If you post your code we would have a better chance to help you.

Did you use the macro recorder when creating the macro?

Possibly you have the sheet name hard-coded in the code.

If you replace that hard-coded name with ActiveSheet perhaps would be better.


Gord Dibben Excel MVP

On Mon, 14 Mar 2005 08:07:01 -0800, "Dave White"
wrote:

I tried to create an excel macro for the 'Sheet Hide' command from the menu.
All I did was corrupted this command on the menu. Now it always tries to hide
the sheet in the file I had open when I tried to create the macro.

Is there something less drastic than un-installing/re-installing office?

TIA

Dave White