Excel 2007: Simple VBA Procedures not showing in Macros List 1

[kjv1611]

Seems like this should be something simple, but apparently it's not, or I'm badly overlooking it.

In Excel 2007, I just create a VBA procuedure which I wanted to test and set to a button in the quick access toolbar. Well, I created the code, but it doesn't show in the Macros list.

Private Sub PasteSpec_Values()
    Selection.PasteSpecial Paste:=xlPasteValues
End Sub

According to this article:

http://msdn.microsoft.com/en-us/library/dd890502(office.11).aspx

It sounds like if the code includes a parameter, then it won't show in that list. Well, this code doesn't include any parameters. Also, I tried compiling, saving everything, closing and reopening Excel.

The code is in the Modules section of my PERSONAL.XLS worksheet... is it also possible that I need to resave my PERSONAL.XLS worksheet to PERSONAL.XLST for some of the code to show up in my Macros list?? The reason its in XLS format is b/c I just copied up the PERSONAL.XLS from when I used Office 2003.

Thanks for any advice/suggestions/references/jabs.

--

"If to err is human, then I must be some kind of human!" -Me

 

[SkipVought]

Try removing the PRIVATE.

You ought to be able to find a ToolBar Icon that does PasteValues. No VBA required.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kjv1611]

Probably, but of course I didn't look.

--

"If to err is human, then I must be some kind of human!" -Me

 

[kjv1611]

Just verified it - yep, you were right on the "remove PRIVATE" part. Duh - Me.

Maybe I'll look later for a built-in toolbar button for that... seems I found one before. But I don't remember. And I'll probably forget to look

--

"If to err is human, then I must be some kind of human!" -Me

 

[SkipVought]

As I recall, it looks like a clipboard with a 12 on it, at least in 2003.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}