Excel 2007: deleting macro from personal.xlsb

C

Carl LaFong

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?
 
N

NickHK

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
 
C

Carl LaFong

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.
 
N

NickHK

Carl,
I do not use XL2007, but in previous versions you had to go to Window>Unhide
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
 
J

Jim Rech

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
| 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.
|
|
|
|
|
 
C

Carl LaFong

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.
 
J

Jim Rech

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
| 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.
|
|
 
C

Carl LaFong

Jim Rech said:
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:

You are right!! Due to aging eyes, I have always used 800 x 600 and those
buttons are not shown at that resolution, but pop up at higher resolution.

I have never seen such behavior in all my computing years and am now
wondering what other commands in Excel and other apps I have not seen.

I don't think I can stick with higher resolutions, but I will try to see if
I can get by using the magnification slider in the lower right corner, at
least for Excel.

Thanks again.
 
J

Jim Rech

I have never seen such behavior in all my computing years

Well that's the new Ribbon! Let's mark you down as a satisfied customer!<g>

--
Jim
|
| | > 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
|
|
| Jim:
|
| You are right!! Due to aging eyes, I have always used 800 x 600 and those
| buttons are not shown at that resolution, but pop up at higher resolution.
|
| I have never seen such behavior in all my computing years and am now
| wondering what other commands in Excel and other apps I have not seen.
|
| I don't think I can stick with higher resolutions, but I will try to see
if
| I can get by using the magnification slider in the lower right corner, at
| least for Excel.
|
| Thanks again.
|
|
|
 
N

NickHK

Jim,
I don't have Office2007. So you are saying menu items disappear at certain
resolutions ?

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top