Doubt in macro..try to group rows

**charles.2345** · 05-26-2008, 03:09 PM

Hi everybody,

I am charles.. I created an account because I love Excel and get some doubts sometimes.. Plese help me resolve this problem:

I created a sheet. There i wanted to group some rows. I tried creating a macro (I failed. I'm new to macros..). But some macro was created... Now I tried to group the rows manually. It said macros are disabled.... I lowered the security.. No good. I deleted the macro (Actually deleted the module in VB). Now when I try to group the rows it says macro so-and-so NOT FOUND... (now i know i successfully deleted it) but my question is why does it need/look for a macro when I am grouping the rows myself.... Even if there was an (unsuccessful) attempt to create a macro to group rows, I should still be able to do it manually, right?

Thanks in advance,
Charles.

**Simon Lloyd** · 05-26-2008, 04:00 PM

Hmmmmm, we don't know without seeing the workbook, but when you get excel to perform automated native tasks it readily creates a named range, when creating a macro even if you don't record anything excel still expects code to be in place, if a cell or some other object has a macro assigned to it it will always look for that until you remove the reference.

I don't know how you want the rows grouping or why or over which range? however there are many grouping conventions heres just one:

Please Login or Register  to view this content.

the format Cells(x,x) is different that Range("Xx") in the fact that with cells it is like this Cells(Row number, Column Number) in the range format its Range("Column Letter RowNumber"), the grouping i supplied there groups rows 2 starting at column 1 to rows 8 finishing at the last entry of data in that row (the column). why not let us know what you are trying to do and see if we can help your out?

**charles.2345** · 05-26-2008, 09:17 PM

Hi, I can understand that you can really help me when you can see the file... I have loaded the file on box.net

I want to group the rows 1 to 7 so that there is a + sign in front of row 1, which I have to click to see the rows 2 to 7.

If I select the rows and do Menu Data->Group and outline->group it says macro missing... Could you please help me so that I never see this meesage and I can group as many lines as I want??

Thanks,
Chalres.

**Simon Lloyd** · 05-26-2008, 09:37 PM

Charles never give out your login or password for any account you have on the net, i have deleted it for your own safety and uploaded your file here.

You can always upload your file here by scrooling to the bottom of your new post window and click on Manage attachments!

**Simon Lloyd** · 05-26-2008, 09:46 PM

I just tried your file and using group works fine!, you need to look in PERSONAL.xls to see if macro's referring to this workbook are there here's your file loaded back!

**charles.2345** · 05-26-2008, 11:50 PM

Hi Simon,

Thanks man... I did not know you can upload files here itself. I just google PERSONAL.xls and created and hid it.. It was not even there so this is not the issue surely?? I downloaded the file you reloaded and it still gives the same message as "The macro 'music.xls!group_Macro' cannot be found." I can tell that music.xls is the original xls file where I had this issue (Acually the file macro error.xls was just some rows copied from one sheet of this bigger music.xls) and group_Macro was the macro I saved in music.xls. Somehow it still thinks that the macro group_Macro is only allowed to group rows and it can't be done manually... I'm attaching the original music.xls itself.. See any sheet here allows grouping, If so, then there is something on my computer/settings and not this file??

Thanks,
Charles.

**royUK** · 05-27-2008, 01:54 AM

There's no code in the original workbook, there is no prompt to enable macros.

**Simon Lloyd** · 05-27-2008, 02:52 AM

Nothing wrong with that workbook, as Roy says no code and no references or named ranges, so you maybe you have alinked workbook? it works fine on my PC.

**charles.2345** · 05-27-2008, 11:19 AM

HI guys,

I dunno what is a linked workbook... but if it works on your comp.. I think i'll just cut paste the text in notepad and then back to a fresh book.. thanks all of you..

Charles.

**charles.2345** · 06-02-2008, 04:09 PM

Hello everyone,

The problem has spread to other sheets. LOL

I can not group any data in any sheet of any xls file (workbook). I am attaching two screenshots of what the message looks like when I try to group some rows in a brand new xls file (book 2.xls).

Note that grouping data manually opens the file 'music.xls' (see windows taskbar in attached image 'macro in c drive.JPG') and it says that the file is locked and if I select 'read-only' or 'notify' on the popup, then it tries to find the macro called 'music.xls!group_Macro', which was a macro I created (name of macro = group_Macro) in the file c:\aaa_h1\music.xls to group rows . But I deleted the macro as I wanted to do the groupings manually but excel somehow still searches for this macro whenever I want to group any row in any file manually. Some times the error simply reads "The macro 'music.xls!group_Macro' cannot be found/" as in the attached file (group_macro not found.jpg).

Please help me folks... I have tried to repair MS office..it didn't work.. then I reinstalled MS office and it still didn't work. I know installing windows XP Professional again will make it work but that will waste over 24 hours... Kindly see where the problem lies. I am also attaching music.xls (but I think the problem is somewhere else)

Best regards,
Charles.

**Simon Lloyd** · 06-02-2008, 04:21 PM

Pictures are no good to us, we need the workbooks, not copied or similar or edited - just the offending workbooks, it's nothing to do with repairing or any such thing, you simply are referencing a macro that doesn't exist allbeit you know its there but there may be a typo in the name or the workbook was previously located elsewhere and moved there are many ways the problem could happen, but its not a fault with excel!

**charles.2345** · 06-02-2008, 04:33 PM

Hello everyone,

I see that you earlier looked at music.xls (from post #6 on this thread) and told me that you are able to group rows. But I am not able to do that even after reinstalling MS excel. What could be wrong. It says macro not found...

Best regards,
Charles

**Simon Lloyd** · 06-02-2008, 04:50 PM

Did you read my post?

**charles.2345** · 06-02-2008, 10:20 PM

Hi Simon,

I read the post... you are saying that :

you simply are referencing a macro that doesn't exist allbeit you know its there but there may be a typo in the name or the workbook was previously located elsewhere and moved there are many ways the problem could happen, but its not a fault with excel!

How to resolve the problem of "referencing a macro that doesn't exist "?

I don't want no macros, I want to group my rows manually...

Thanks and best regards,
Charles.

**charles.2345** · 07-15-2008, 11:23 AM

Hi Experts,

Writing about the same trouble again..But there has been some progress. I was able to group rows in my excel sheets now by creating a button for group in a toolbar I created. I am surprised that it worked. The original link for group (menu: Data->Group and outline) doesn't work but this toolbar that I created worked. How is that? I don't want to be creating this toolbar every time I install Excel (i have to reformat my windows almost every 3-4 months...).

Another problem I am facing is that when I click on MS Excel from start-All programs it says the PERSONAL.XLS is locked for editing but this does not happen if i click on File->New from an already open excel file.. Why? I am attaching my personal.xls and a new file I just created .. May be it will help you know what is wrong. And yes I still can't group rows using (menu: Data->Group and outline-Group) (Please read earlier posts in this thred for what actually happens when I do that)

I am on Windows XP professional and the PERSONAL.xls was in folder C:\Documents and Settings\Charles\Application Data\Microsoft\Excel\XLSTART\

Question: What is file PERSONAL.XLSB? Is it same as PERSONAL.xls?

Thanks and hope you will throw some light.

Best regards,
Charles.