Dear All,
Thanks for your support. Special thanks to Mr. Noorain for solving the my problem. Best Regards, K Sagar On Fri, May 25, 2012 at 5:03 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote: > Dear Sagar, > > You have recorded a macro with Short-cut key ctrl+A > > Please remove this macro from below path : > UserName > C:\Documents and Settings\*noorain.ansari*\Application > Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB > > > Hope after removal of Recorded Macro, ctrl+A will work Fine in your system. > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Fri, May 25, 2012 at 4:45 PM, SAGAR KASANGOTTUWAR < > sagarkasangottu...@gmail.com> wrote: > >> Dear All, >> >> Please find attached file for the debugging the error 1004 so kindly give >> the solution for the same. >> >> Thanks & Regards, >> Sagar Kasangottuwar >> >> >> On Fri, May 25, 2012 at 3:41 PM, sreenivas kammari < >> sreenivas...@gmail.com> wrote: >> >>> I agree with David, that could be the one reason. try out that. >>> >>> On Fri, May 25, 2012 at 10:51 AM, David Grugeon <grug...@gmail.com> >>> wrote: >>> > The most likely cause is that you have a macro assigned to Ctrl-A >>> either in >>> > an open workbook, an addin, or in your personal macros workbook. This >>> last >>> > is a hidden workbook which opens up when you open excel. You can see >>> its >>> > macros in the VBE so press Alt-F11 and have a look. There may be a >>> macro >>> > called AutoOpen or similar which sets up the key assignment. >>> > >>> > If Ctrl-A has its default assignment (selecting the current area of the >>> > active sheet) it will not run a macro and will not give the error. >>> > >>> > You will need to find out what it is doing, and either remove the >>> > reassignment of the key combination or fix the faulty macro. >>> > >>> > The error is likely to be because it is trying to run a macro which is >>> > designed for a specific workbook, but that workbook is not in use or >>> is not >>> > active. >>> > >>> > Regards >>> > David >>> > >>> > On 25 May 2012 14:24, SAGAR KASANGOTTUWAR < >>> sagarkasangottu...@gmail.com> >>> > wrote: >>> >> >>> >> Dear All, >>> >> >>> >> This error is coming in all the sheets whenever I open any excel >>> sheet and >>> >> Press Crl.+A then error 1004 is showing on the screen. >>> >> >>> >> Thanks & Regards, >>> >> K Sagar >>> >> >>> >> >>> >> On Thu, May 24, 2012 at 6:05 PM, dguillett1 <dguille...@gmail.com> >>> wrote: >>> >>> >>> >>> Provide an excel file. >>> >>> >>> >>> Don Guillett >>> >>> Microsoft MVP Excel >>> >>> SalesAid Software >>> >>> dguille...@gmail.com >>> >>> >>> >>> From: SAGAR KASANGOTTUWAR >>> >>> Sent: Wednesday, May 23, 2012 2:30 AM >>> >>> To: excel-macros@googlegroups.com >>> >>> Subject: $$Excel-Macros$$ Error 1004 at the time of Crl. + A command >>> >>> >>> >>> Dear all, >>> >>> >>> >>> I am facing the problem in MS excel command Crl + A. Whenever I run >>> >>> command Crl+A 1004 error in EXECL file. >>> >>> >>> >>> Kindly help me for resolve this error. >>> >>> >>> >>> Thanks & Regards, >>> >>> Sagar Kasangottuwar >>> >>> -- >>> >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please >>> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>> Advice will >>> >>> not get quick attention or may not be answered. >>> >>> >>> >>> 2) Don't post a question in the thread of another member. >>> >>> >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> >>> measure. >>> >>> >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum >>> in >>> >>> signatures are prohibited. >>> >>> >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum >>> >>> owners and members are not responsible for any loss. >>> >>> >>> >>> >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> >>> >>> To unsubscribe, send a blank email to >>> >>> excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >>> -- >>> >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please >>> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>> Advice will >>> >>> not get quick attention or may not be answered. >>> >>> >>> >>> 2) Don't post a question in the thread of another member. >>> >>> >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> >>> measure. >>> >>> >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum >>> in >>> >>> signatures are prohibited. >>> >>> >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum >>> >>> owners and members are not responsible for any loss. >>> >>> >>> >>> >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> >>> >>> To unsubscribe, send a blank email to >>> >>> excel-macros+unsubscr...@googlegroups.com >>> >> >>> >> >>> >> -- >>> >> FORUM RULES (986+ members already BANNED for violation) >>> >> >>> >> 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please >>> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>> Advice will >>> >> not get quick attention or may not be answered. >>> >> >>> >> 2) Don't post a question in the thread of another member. >>> >> >>> >> 3) Don't post questions regarding breaking or bypassing any security >>> >> measure. >>> >> >>> >> 4) Acknowledge the responses you receive, good or bad. >>> >> >>> >> 5) Cross-promotion of, or links to, forums competitive to this forum >>> in >>> >> signatures are prohibited. >>> >> >>> >> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum >>> >> owners and members are not responsible for any loss. >>> >> >>> >> >>> >> >>> ------------------------------------------------------------------------------------------------------ >>> >> To post to this group, send email to excel-macros@googlegroups.com >>> >> >>> >> To unsubscribe, send a blank email to >>> >> excel-macros+unsubscr...@googlegroups.com >>> >> >>> >> -- >>> >> David Grugeon >>> >> >>> > -- >>> > FORUM RULES (986+ members already BANNED for violation) >>> > >>> > 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>> Advice will >>> > not get quick attention or may not be answered. >>> > >>> > 2) Don't post a question in the thread of another member. >>> > >>> > 3) Don't post questions regarding breaking or bypassing any security >>> > measure. >>> > >>> > 4) Acknowledge the responses you receive, good or bad. >>> > >>> > 5) Cross-promotion of, or links to, forums competitive to this forum in >>> > signatures are prohibited. >>> > >>> > NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum >>> > owners and members are not responsible for any loss. >>> > >>> > >>> ------------------------------------------------------------------------------------------------------ >>> > To post to this group, send email to excel-macros@googlegroups.com >>> > >>> > To unsubscribe, send a blank email to >>> > excel-macros+unsubscr...@googlegroups.com >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
