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 <sagarkasangottu...@gmail.com> >> *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 > > <excel-macros%2bunsubscr...@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
