I am a complete novice with macros, but have been playing with some simple
examples.

I have a macro created that I want to delete, but when I navigate to
developer/macros and choose the macro, I am told I can't delete it because
it resides in the hidden personal macro workbook file (personal.xlsb). It
says to use the unhide command in order to delete the macro, but I can't
find that particular command.

Some unhide commands are at home/cells/format dropdown, but I don't see
anything relevant. There is no workbook choice. Not even a greyed out
workbook choice. Which might lead me to believe I have no hidden workbooks,
but nonetheless I get the message to unhide.

I see some hide choices at view/show-hide, but nothing relevant.

I also notice I have a blank worksheet at the end of my Excel file titled
simply "sheet 1". Is this related to macros and can it be deleted?

Carl,
It may be easier to go through the VBE:
-Alt+F11
-On the left you should have a list of open workbooks. Find the required,
probably called "VBAProject (PERSONAL.XLS)"
-Click the "+" to its left, if it is not already expanded.
-Click the "+" to left of the "Modules" folder, if it is not already
expanded.
-Double click each module you find there are check the VBA code you find in
it for the routine you wish to delete.
-Select and delete everything from the "Sub YourMacro" to "End sub",
inclusive.

NickHK

"Carl LaFong" wrote in message
...
I am a complete novice with macros, but have been playing with some simple
examples.

I have a macro created that I want to delete, but when I navigate to
developer/macros and choose the macro, I am told I can't delete it because
it resides in the hidden personal macro workbook file (personal.xlsb). It
says to use the unhide command in order to delete the macro, but I can't
find that particular command.

Some unhide commands are at home/cells/format dropdown, but I don't see
anything relevant. There is no workbook choice. Not even a greyed out
workbook choice. Which might lead me to believe I have no hidden
workbooks,
but nonetheless I get the message to unhide.

I see some hide choices at view/show-hide, but nothing relevant.

I also notice I have a blank worksheet at the end of my Excel file titled
simply "sheet 1". Is this related to macros and can it be deleted?

NickHK:

Thanks for the help. Your suggestion worked.

How do you explain the lack of a relevant unhide command?? Excel 2007 bug? A
peculiarity with my particular file or situation? Is this a known issue?

Do you have any comment about the blank "sheet 1" at the end of my file that
I mentioned in my original post? I know I did not make that particular tab,
so I am guessing it was created by Excel and has something to do with macros
and maybe I shouldn't delete it?? If nothing else, I can hide it.

Carl,
I do not use XL2007, but in previous versions you had to go to WindowUnhide
on the excel menu bar. Then you will be able to select the desired hidden
workbook.

As for the "Sheet1", if you did not insert it, it may have been created by a
macro, but we cannot tell without seeing your XL setup.
It may have been there, but you did not notice, as "Sheet1" suggests the
first in a workbook.
All workbooks need at least 1 sheet, although this can be a chart or macro
sheet intead of a worksheet.
As for deleting it only you can tell if it is important or not.

NickHK

"Carl LaFong" wrote in message
...
NickHK:

Thanks for the help. Your suggestion worked.

How do you explain the lack of a relevant unhide command?? Excel 2007 bug?
A
peculiarity with my particular file or situation? Is this a known issue?

Do you have any comment about the blank "sheet 1" at the end of my file
that
I mentioned in my original post? I know I did not make that particular
tab,
so I am guessing it was created by Excel and has something to do with
macros
and maybe I shouldn't delete it?? If nothing else, I can hide it.

A bit of nomenclature, Carl. The workbook isn't hidden, its window is.
Same thing when you have only one window of course but it helps you to find
the command to think of it as a Window command.

View tab, Window group, Unhide button.

--
Jim
"Carl LaFong" wrote in message
...
| NickHK:
|
| Thanks for the help. Your suggestion worked.
|
| How do you explain the lack of a relevant unhide command?? Excel 2007 bug?
A
| peculiarity with my particular file or situation? Is this a known issue?
|
| Do you have any comment about the blank "sheet 1" at the end of my file
that
| I mentioned in my original post? I know I did not make that particular
tab,
| so I am guessing it was created by Excel and has something to do with
macros
| and maybe I shouldn't delete it?? If nothing else, I can hide it.
|
|
|
|
|

Jim:

I may well have lost my mind, but in Excel 2007 I don't see any "Unhide"
button in view tab, window group.

In the Window group, I see

new window
arrange all
freeze panes
save workspace
switch windows

and 3 buttons representing

view side by side
synchronous scrolling
reset window position

I see a "show-hide" under view, way over to the left of the zoom group, but
it has no relevant choices and it is not in the window group.

What am I missing?? I admit to not having nomenclature down, but I have to
trust my eyes.

If you haven't maximized Excel do so now. Unless you have a pretty low
screen resolution you should see that the three buttons to the right of New
Window, Arrange All and Freeze Panes now have captions - Split, Hide,
Unhide.

--
Jim
"Carl LaFong" wrote in message
...
| Jim:
|
| I may well have lost my mind, but in Excel 2007 I don't see any "Unhide"
| button in view tab, window group.
|
| In the Window group, I see
|
| new window
| arrange all
| freeze panes
| save workspace
| switch windows
|
| and 3 buttons representing
|
| view side by side
| synchronous scrolling
| reset window position
|
| I see a "show-hide" under view, way over to the left of the zoom group,
but
| it has no relevant choices and it is not in the window group.
|
| What am I missing?? I admit to not having nomenclature down, but I have to
| trust my eyes.
|
|